Please enter your details here.
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)
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: