Please enter your details here.
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 windows displays a list of all forms and modules making up your application.
To break up long lines of code, the line continuation character in VBA is
This control is used for titles/captions
An array that maintains multiple sets of information referenced by more than one index is called ________________
___________ indicates whether a particular condition is on or off
Which of the following statement is not a looping statement in VBA?
Which of the following is default in VBA for data passing?
Which property for a textbox allows the textbox to accept more than 1 line of data entry?
To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
What value is stored in a variable of type single if we try to assign the variable to the value 634?
Which of the following arithmetic operations has the highest level of precedence?
The value returned by InputBox is a string
Why Macro is used
Private Procedure can be called from anywhere in the project
What data type can hold any type of data?
What will the value of ThisVar be after the following lines of code execute?
Dim ThisVar As String Dim MyName = "John" ThisVar = MyName & "John"
The _______________ statement first executes the statements and then tests the condition after each execution
To close a form named Form1, you can use:
Basic Excel Object model as follows:
32-bit Software/Applications can be installed on:
What will be the output of the following statement?
txtBox.Text = FormatCurrency(1234.567)
A ______________ returns a value to the part of the program that called it.
A single Case statement can contain multiple values
Study the screenshot below. What is the appropriate action to take when a workbook displays this message (Security Warning Macros have been disabled)?
___________ statement enables us to trap runtime error.
Which property determines whether a control is displayed to the user?
The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used
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?
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