Please enter your details here.
Which property determines whether a control is displayed to the user?
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
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
___________ control is used to provide an identifiable grouping for other controls
This operator reverses the truth value of an expression; making a true expression false and a false expression true.
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)
The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used
32-bit Software/Applications can be installed on:
Which of the following statement is not a looping statement in VBA?
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
There can be different data types of an element in an array
_______________ is the function to compare 2 strings.
What will the value of ThisVar be after the following lines of code execute?
Dim ThisVar As String Dim MyName = "John" ThisVar = MyName & "John"
You have declared 4 variables
Which of these variable declarations is not a valid VBA statement?
Which windows displays a list of all forms and modules making up your application.
___________ statement enables us to trap runtime error.
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 is the color of comments?
A Combo box is loaded in the From_Initialize event with:
Combo1.AddItem “Red”
Combo1.AddItem “Blue”
Combo1.AddItem “Green”
Which of the following is default in VBA for data passing?
Which character in VBA, indicates start of a comment
A ______________ returns a value to the part of the program that called it.
Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
___________ function is used to return a copy of a string without leading spaces.
Do…Loop... Until code block is always executed once.
___________ indicates whether a particular condition is on or off
The value returned by InputBox is a string
__________ are the attributes of an object that control the object's appearance and behavior.
This control is used for titles/captions
The _______________ control used to insert image to the form