What data type can hold any type of data?

What value is stored in a variable of type single if we try to assign the variable to the value 634?

To close a form named Form1, you can use:

Which character in VBA, indicates start of a comment

An object is composed of :

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

End Sub

Private Sub ShowAge()

Dim UserAge As Integer

UserAge = 0

MsgBox (UserAge)

End Sub

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

A Combo box is loaded in the From_Initialize event with:

Combo1.AddItem “Red”

Combo1.AddItem “Blue”

Combo1.AddItem “Green”

This control is used for titles/captions

There can be different data types of an element in an array

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

VBA Code run by

32-bit Software/Applications can be installed on:

Study the screenshot below. What is the appropriate action to take when a workbook displays this message (Security Warning Macros have been disabled)?

A loop that does not have the way of stopping is called a ___________

A single Case statement can contain multiple values

What will be the output of the following statement?

txtBox.Text = FormatCurrency(1234.567)

Which part of VBA window, refers to area where code is written.

Why Macro is used

You have declared 4 variables

 Which of these variable declarations is not a valid VBA statement?

___________ function is used to return a copy of a string without leading spaces.

Which windows displays a list of all forms and modules making up your application.

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

The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used

Do…Loop... Until code block is always executed once.

Which property for a textbox allows the textbox to accept more than 1 line of data entry?

To load graphics on a control at runtime, we have to use the function….

Which event, runs macros automatically in excel VBA while opening Workbook

Private Procedure can be called from anywhere in the project