Please enter your details here.
Which windows displays a list of all forms and modules making up your application.
An array that maintains multiple sets of information referenced by more than one index is called ________________
To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
Which of the following statement is not a looping statement in VBA?
A ____________ is a predefined VB procedure that you can call upon when needed.
What do you need to select to set the developer mode?
Which character in VBA, indicates start of a comment
_______________ is the function to compare 2 strings.
The _______________ control used to insert image to the form
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?
What will be the output of the following statement?
txtBox.Text = FormatCurrency(1234.567)
What property of controls tells the order they receive the focus when the tab key is pressed during run time? it.
To force all variables is a VBA project to be declared, which must be stated in a module?
Which of the following is default in VBA for data passing?
The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used
___________ indicates whether a particular condition is on or off
Basic Excel Object model as follows:
The value returned by InputBox is a string
You have declared 4 variables
Which of these variable declarations is not a valid VBA statement?
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
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
__________ are the attributes of an object that control the object's appearance and behavior.
Do…Loop... Until code block is always executed once.
Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
___________ statement enables us to trap runtime error.
Which event, runs macros automatically in excel VBA while opening Workbook
To close a form named Form1, you can use:
A ______________ returns a value to the part of the program that called it.
This operator reverses the truth value of an expression; making a true expression false and a false expression true.
What will be the output of the following code?
Sub LoopExample()
Dim StartNumber As Integer
Dim EndNumber As Integer
Dim Answer As Integer
Answer = 5
EndNumber = 5
For StartNumber = 1 To EndNumber
Answer = Answer + EndNumber
Next StartNumber
MsgBox Answer
End Sub