Blog

Type the appropriate code to create an If…Then statement that will display a simple message box with the message prompt Time to Reorder if the value in Cell H7 is less than 5.  (4 points)

What must be typed first if you want to type a comment in Visual Basic?

In the space provided below, type the appropriate code to create a simple Message Box that tells the user the following message:  You are brilliant!  You do not need buttons or a title for this Message Box.  (1 point)

Type the appropriate line of code to move from Cell A2 to Cell C1 using relative referencing.  (1 point)

Comments typed into Visual Basic Editor will be displayed in purple font.

The property you change for an Option Button to indicate what you want the Option Button to say is called the Description.

You define variables when you create a Do Loop.

When you record a macro, Excel automatically creates the code for the macro in Visual Basic Editor.

You want to create a Spin Button in Cell C4 that will allow the user to only click on arrows to change the student age displayed in Cell B4.  The student’s age should not be less than 13 or greater than 19.     A B C D E F 1 Student Data           2             3 Student Name Kristen Hockman     9 Freshman 4 Student Age 17     10 Sophomore 5 Year in School 11     11 Junior 6         12 Senior   What properties need to be changed in order to create this Spin Button, and what should each of these properties be set at?  (3 points)

The Project Explorer Window is displayed at the bottom of Visual Basic Editor.