Macro Practice Questions

In the Visual Basic command “ActiveWorkbook.Save”, ActiveWorkbook is a(n):

• Property

• Object

• Method

A macro that will run every time the file is opened is called a ____________ macro.

• User-Defined Function

• Public Macro

• Private Macro

The _______________ window in the Visual Basic Editor is where you access the modules containing public macros you have created.

• Project Explorer Window

• Code Window

• Local Window

A loop that will allow you to run a set of VBA statements over and over again until a specified condition is met is known as a:

• For...Next Loop

• Do...Loop

• Repeat...Loop

The first word in the first line of a public macro is:

• Sub

• Public

• Macro

What button do you click on to record a new macro?

• New Macro Wizard

• Create Macro

• Record Macro

What tab do we use in Excel to work with macros?

• Developer

• Creator

• Macro

A user-defined function must be created in __________ in Visual Basic Editor.

• This Workbook

• A Module

• A Sheet

The last line of code for a user-defined function is:

• End Sub

• End Macro

• End Function

The first word used in the line of code to define a variable is:

• Define

• Declare

• Dim