Please enter your details here.
To close a form named Form1, you can use:
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?
What is the color of comments?
___________ statement enables us to trap runtime error.
_______________ is the function to compare 2 strings.
Do…Loop... Until code block is always executed once.
When the form is first referenced in any manner by program,the triggered event is….
___________ control is used to provide an identifiable grouping for other controls
Which part of VBA window, refers to area where code is written.
Basic Excel Object model as follows:
The _______________ statement first executes the statements and then tests the condition after each execution
What will be the output of the following statement?
txtBox.Text = FormatCurrency(1234.567)
Which property for a textbox allows the textbox to accept more than 1 line of data entry?
The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used
Why Macro is used
What value is stored in a variable of type single if we try to assign the variable to the value 634?
This operator reverses the truth value of an expression; making a true expression false and a false expression true.
Private Procedure can be called from anywhere in the project
___________ indicates whether a particular condition is on or off
What will the value of ThisVar be after the following lines of code execute?
Dim ThisVar As String Dim MyName = "John" ThisVar = MyName & "John"
Which of the following arithmetic operations has the highest level of precedence?
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
VBA Code run by
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
To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
The value returned by InputBox is a string
Which of the following statement is not a looping statement in VBA?
There can be different data types of an element in an array
Which property determines whether a control is displayed to the user?
An object is composed of :