Please enter your details here.
A ____________ is a predefined VB procedure that you can call upon when needed.
A ______________ returns a value to the part of the program that called it.
Do…Loop... Until code block is always executed once.
Which of the following statement is not a looping statement in VBA?
Which part of VBA window, refers to area where code is written.
Study the screenshot below. What is the appropriate action to take when a workbook displays this message (Security Warning Macros have been disabled)?
This control is used for titles/captions
To force all variables is a VBA project to be declared, which must be stated in a module?
A loop that does not have the way of stopping is called a ___________
32-bit Software/Applications can be installed on:
___________ control is used to provide an identifiable grouping for other controls
Private Procedure can be called from anywhere in the project
The value returned by InputBox is a string
You have declared 4 variables
Which of these variable declarations is not a valid VBA statement?
Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
What will the value of ThisVar be after the following lines of code execute?
Dim ThisVar As String Dim MyName = "John" ThisVar = MyName & "John"
What property of controls tells the order they receive the focus when the tab key is pressed during run time? it.
There can be different data types of an element in an array
Why Macro is used
What data type can hold any type of data?
The _______________ statement first executes the statements and then tests the condition after each execution
To close a form named Form1, you can use:
To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
Which property determines whether a control is displayed to the user?
What will be the output of the following statement?
txtBox.Text = FormatCurrency(1234.567)
What value is stored in a variable of type single if we try to assign the variable to the value 634?
The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used
__________ are the attributes of an object that control the object's appearance and behavior.
___________ statement enables us to trap runtime error.
Which windows displays a list of all forms and modules making up your application.