Please enter your details here.
To load graphics on a control at runtime, we have to use the function….
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
Do…Loop... Until code block is always executed once.
Which event, runs macros automatically in excel VBA while opening Workbook
___________ control is used to provide an identifiable grouping for other controls
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?
An object is composed of :
Which of the following statement is not a looping statement in VBA?
Which property for a textbox allows the textbox to accept more than 1 line of data entry?
The _______________ control used to insert image to the form
A Combo box is loaded in the From_Initialize event with:
Combo1.AddItem “Red”
Combo1.AddItem “Blue”
Combo1.AddItem “Green”
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
Private Procedure can be called from anywhere in the project
__________ are the attributes of an object that control the object's appearance and behavior.
The value returned by InputBox is a string
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
Private Sub ShowAge()
Dim UserAge As Integer
UserAge = 0
MsgBox (UserAge)
Which of the following arithmetic operations has the highest level of precedence?
To close a form named Form1, you can use:
A loop that does not have the way of stopping is called a ___________
Which windows displays a list of all forms and modules making up your application.
What value is stored in a variable of type single if we try to assign the variable to the value 634?
You have declared 4 variables
Which of these variable declarations is not a valid VBA statement?
Which of the following statements is not true about user-defined functions?
A single Case statement can contain multiple values
This operator reverses the truth value of an expression; making a true expression false and a false expression true.
Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
What will be the output of the following statement?
txtBox.Text = FormatCurrency(1234.567)
VBA Code run by
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 data type can hold any type of data?