VBA MCQs

Which of these is not a Visual Basic object?

Declaring a public variable allows the user to..

What does a VBA macro consist of?

The RowSource property of a Combo Box control allows the user to:

Which worksheet event can be used to run a procedure upon deleting the contents of a cell?

To concatenate two lines of VBA code into one line, insert which character between the two joined lines?

To create one array variable to store monthly mortgage rates over the course of a year, the following is the best declaration statement.

Choose the function used to send an table's contents in Excel format by email from Access.

Choose the VBA code to allow you to obtain the value from Row 2 and Column 3 of a mutliple column listbox.

A VBA unit is called a _____.