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

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

Which of the following statement is not a looping statement in VBA?

Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?

What is the color of comments?

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

The _______________ control used to insert image to the form

A ______________ returns a value to the part of the program that called it.

Which event, runs macros automatically in excel VBA while opening Workbook

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

Given that x = 7, y = 2, and z = 4, the following If block will display “TRUE”. If (x > y) Or (y > z) Then txtBox.Text = “TRUE” End If

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?

___________ statement enables us to trap runtime error.

Which property determines whether a control is displayed to the user?

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

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

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

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?

This control is used for titles/captions

The value returned by InputBox is a string

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

Basic Excel Object model as follows:

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

Which character in VBA, indicates start of a comment

___________ function is used to return a copy of a string without leading spaces.

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

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

A Combo box is loaded in the From_Initialize event with:

Combo1.AddItem “Red”

Combo1.AddItem “Blue”

Combo1.AddItem “Green”

A single Case statement can contain multiple values

To close a form named Form1, you can use: