Do…Loop... Until code block is always executed once.

__________ are the attributes of an object that control the object's appearance and behavior.

Basic Excel Object model as follows:

To force all variables is a VBA project to be declared, which must be stated in a module?

Which is the conversion for the following If...Then...ElseIf statement to a Select...Case statement?

If intValue > 0 And intValue <= 9 Then

discount = .10

Else If intValue >9 And intValue <=20

discount = .15

Else

discount = .20

To close a form named Form1, you can use:

Which of the following is default in VBA for data passing?

An array that maintains multiple sets of information referenced by more than one index is called ________________

When the block of code finishes the execution, what will the final value of X be?

Public Sub Example ()

Dim Y As Integer

Dim X As Integer

X = 0

Y = 10

For Count = Y To 1 Step -2

X = X + Y

If Y = (Y = 1) Then

Exit For

End If

Next Count

X = X / X

MsgBox X

End Sub

Which Case clause will be true whenever the value of the selector in a Select Case block is between 1 and 5 or is 8?

You have declared 4 variables

 Which of these variable declarations is not a valid VBA statement?

Private Procedure can be called from anywhere in the project

Which of the following statements is not true about user-defined functions?

What data type can hold any type of data?

Which property for a textbox allows the textbox to accept more than 1 line of data entry?

A Combo box is loaded in the From_Initialize event with:

Combo1.AddItem “Red”

Combo1.AddItem “Blue”

Combo1.AddItem “Green”

What will be the output of the following statement?

txtBox.Text = FormatCurrency(1234.567)

Which windows displays a list of all forms and modules making up your application.

Which part of VBA window, refers to area where code is written.

A ____________ is a predefined VB procedure that you can call upon when needed.

Given the following section of code, if a programmer called the GetAge() subroutine, what value would the message box display? 

Private Sub GetAge()

Dim UserAge As String

UserAge = 10

UserAge = InputBox("Enter your age", "Get Age")

Call ShowAge

End Sub

Private Sub ShowAge()

Dim UserAge As Integer

UserAge = 0

MsgBox (UserAge)

End Sub

A single Case statement can contain multiple values

Suppose you are designing an application for admissions to a college or university, and you need to decide how to provide the user with a selection of racial backgrounds. Which control would be most appropriate?

___________ indicates whether a particular condition is on or off

What value is stored in a variable of type single if we try to assign the variable to the value 634?

A loop that does not have the way of stopping is called a ___________

Why Macro is used

To load graphics on a control at runtime, we have to use the function….

There can be different data types of an element in an array

To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?