Please enter your details here.
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
End Sub
Private Sub ShowAge()
Dim UserAge As Integer
UserAge = 0
MsgBox (UserAge)
_______________ is the function to compare 2 strings.
To force all variables is a VBA project to be declared, which must be stated in a module?
Which event, runs macros automatically in excel VBA while opening Workbook
When the form is first referenced in any manner by program,the triggered event is….
You have declared 4 variables
Which of these variable declarations is not a valid VBA statement?
Which character in VBA, indicates start of a comment
___________ function is used to return a copy of a string without leading spaces.
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
VBA Code run by
An array that maintains multiple sets of information referenced by more than one index is called ________________
Which part of VBA window, refers to area where code is written.
A single Case statement can contain multiple values
Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
What value is stored in a variable of type single if we try to assign the variable to the value 634?
What do you need to select to set the developer mode?
A ______________ returns a value to the part of the program that called it.
Study the screenshot below. What is the appropriate action to take when a workbook displays this message (Security Warning Macros have been disabled)?
Which of the following is default in VBA for data passing?
The _______________ control used to insert image to the form
To close a form named Form1, you can use:
Why Macro is used
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?
___________ indicates whether a particular condition is on or off
To load graphics on a control at runtime, we have to use the function….
The value returned by InputBox is a string
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?
Do…Loop... Until code block is always executed once.
An object is composed of :