VBA Test

There are two references that must be selected in the Visual Basic Editor in order for any Visual Basic code to run in Excel. What are these two references?

VBA AND MS OFFICE OBJECT LIBRARY

MS EXCEL OBJECT LIBRARY AND MS OFFICE OBJECT LIBRARY

VBA AND EXCEL OBJECT LIBRARY

MS EXCEL OBJECT LIBRARY AND OLE AUTOMATION

What unconditionally pauses the execution of VBA code?

STEP INTO COMMAND

SET NEXT STATEMENT COMMAND

A BREAKPOINT

END STATEMENT

Which directive must be set in order to specify the default member of a class?

ATTRIBUTE

INTERACTIVE

INTERFACE

EXTENSIBILITY

How do you indicate that a line of VBA code is a comment?

INSERT AN UNDERSCORE (_) IMMEDIATELY TO THE LEFT OF THE COMMENT.

INSERT AN UPPERCASE C AS THE LINE'S FIRST CHARACTER.

INSERT A SINGLE QUOTATION MARK (') IMMEDIATELY TO THE LEFT OF THE COMMENT.

INSERT A NUMBER SIGN (#) AS THE LINE'S FIRST CHARACTER.

How does the Close statement differ from the Quit statement?

QUIT CLOSES A FILE; CLOSE CLOSES THE APPLICATION.

CLOSE CLOSES THE CONNECTION TO AN EXTERNAL DATA SOURCE; QUIT CLOSES THE EXTERNAL DATA SOURCE.

CLOSE CLOSES A FILE; QUIT CLOSES THE APPLICATION.

QUIT CLOSES THE LINK TO ANOTHER OFFICE APPLICATION; CLOSE CLOSES THE OTHER APPLICATION ITSELF.

To use VBA code to maintain a different VBA project, you can make use of VBA's extensibility. What is needed to enable extensibility?

INCLUDE A REFERENCE TO MICROSOFT VBA EXTENSIBILITY 5.3, AND SET MACRO SECURITY TO TRUST ACCESS TO THE VBA PROJECT OBJECT MODEL.

INCLUDE A REFERENCE TO MICROSOFT VBA EXTENSIBILITY 5.3.

SET MACRO SECURITY TO TRUST ACCESS TO THE VBA PROJECT OBJECT MODEL.

THE PROJECT'S WORKBOOK SHOULD BE PROTECTED IN THE RIBBON'S REVIEW TAB.

Which variable name is valid in VBA?

MY_VAR

1MYVAR

MY-VAR

_MYVAR

The variable MyVar is declared in a standard module using the Private keyword. Where can a VBA project use that instance of MyVar?

IN ANY MODULE IN THE WORKBOOK WHERE IT IS DECLARED

ONLY IN A TYPE STATEMENT IN THE MODULE WHERE IT IS DECLARED

ONLY IN THE MODULE WHERE IT IS DECLARED

ONLY IN THE PROCEDURE WHERE IT IS DECLARED

A VBA project must declare four classes. How many class modules are needed?

FOUR (ONE FOR EACH CLASS)

TWO (ONE FOR THE PROPERTIES AND ONE FOR THE METHODS)

ONE (EACH CLASS IS DECLARED IN THE SAME MODULE)

AS MANY AS ARE REQUIRED BY THE VARIABLE TYPES THAT THE OBJECTS RETURN

What object is needed to put a userform module in a VBA project?

ASSOCIATED STANDARD CODE MODULE

ASSOCIATED CLASS MODULE

USERFORM CLASS

USERFORM

How should you declare an array that will later be redimensioned?

DIM X (TRUE)

DIM X AS LONG

DIM X(1)

DIM X() AS LONG

Which statement prints the value of the variable X in the Immediate window?

DEBUG.PRINT X

WATCH.VALUE X

PRINT X

IMMEDIATE = X

Which variable type takes the greatest amount of time for VBA to evaluate?

BYTE

STRING

DOUBLE

VARIANT

Which part of the VBE can help you explore VBA syntax?

OBJECT BROWSER

LOCALS WINDOW

OPTIONAL DIALOG

PROJECT EXPLORER

Which property of controls on a user form sets the order in which they get the focus?

CONTROLSOURCE

TAG

ACCELERATOR

TABINDEX

What is the standard term for a variable or value that is passed from one subroutine or function to another?

ELEMENT

ATTRIBUTE

ARGUMENT

REFERENCE

When you define a new class of object, where do you assign a name to it?

IN A STANDARD MODULE'S PROPERTIES

IN THE CLASS MODULE'S NAME

IN A STANDARD MODULE'S CODE

IN THE CLASS MODULE'S CODE

Which statement is true?

LET ESTABLISHES A VALUE IN A CLASS; GET RETURNS A VALUE FROM A CLASS.

LET ESTABLISHES A VALUE IN A CLASS; SET RETURNS A VALUE FROM A CLASS.

GET ESTABLISHES A VALUE IN A CLASS; SET RETURNS A VALUE FROM A CLASS.

SET ESTABLISHES A VALUE IN A CLASS; LET RETURNS A VALUE FROM A CLASS.

A declaration has scope, which has three levels. What are they?

SUBROUTINE, MODULE, AND PROJECT

MODULE, PROJECT, AND AUTOMATION

PROCEDURE, PROJECT, AND GLOBAL

PROCEDURE, PRIVATE MODULE, AND PUBLIC MODULE

At which level can you declare a variable in this way: Private TopSecret As String?

FUNCTION

PROCEDURE

SUBROUTINE

MODULE

How do you declare a constant and establish its value?

CONSTANT MYEMAIL AS STRING = "[email protected]"

CONST MYEMAIL AS STRING = "[email protected]"

PRIVATE MYEMAIL AS STRING = "[email protected]"

DIM PRESERVE MYEMAIL AS STRING = "[email protected]"

Which statement should precede a subroutine's error handler?

STOP

END

RETURN

EXIT SUB

What is used in the Immediate window to display the current value of the variable CountValues?

| COUNTVALUES

: COUNTVALUES

= COUNTVALUES

? COUNTVALUES

What is the principal difference between a class and an object?

THERE IS NO MEANINGFUL DIFFERENCE. THE TERMS ARE USED INTERCHANGEABLY.

A CLASS DECLARES AN OBJECT'S PROPERTIES. AN OBJECT COMPLETES THE DECLARATION BY DEFINING EVENTS AND METHODS.

AN OBJECT IS A TEMPLATE FOR A CLASS.

A CLASS DESCRIBES THE DESIGN OF AN OBJECT. AN OBJECT IS AN INSTANCE OF THAT DESIGN.

When used with an array named MyArray, what is the preerred way to set beginning and ending values of a loop control variable?

FOR I = LBOUND(MYARRAY,1) TO UBOUND(MYARRAY,1)

IT DEPENDS ON WHETHER OPTION BASE 0 OR OPTION BASE 1 IS IN USE.

FOR I = 0 TO UBOUND(MYARRAY,1)

FOR I = 1 TO UBOUND(MYARRAY,1)

How does a class module indicate that it uses a particular interface?

THE NAME OF THE INTERFACE IS PASSED AS A PARAMETER.

BY MEANS OF THE INTERFACE KEYWORD AND THE NAME OF THE INTERFACE

BY MEANS OF THE IMPLEMENTS KEYWORD AND THE NAME OF THE INTERFACE

THE INTERFACE ITSELF IS PART OF THE CLASS MODULE.

What is needed for the contents of Module1 to be availble to other modules in a VBA project, but not to any other VBA project?

SET MODULE LEVEL SCOPE AT THE TOP OF MODULE1.

SET OPTION PRIVATE MODULE AT THE TOP OF MODULE1.

SET OPTION GLOBAL AT THE TOP OF MODULE1.

DECLARE MODULE-LEVEL VARIABLES AS PRIVATE.

SubA passes MyVar to SubB. How can you ensure that MyVar has its original value when control returns to SubA?

DECLARE SUBB AS SUB SUBB(BYVAL MYVAR).

DECLARE SUBB AS SUB SUBB(BYREF MYVAR).

DECLARE SUBB AS SUB SUBB(STATIC MYVAR).

DECLARE SUBB AS SUB SUBB(MYVAR).

Which action will cause your project to reset its variables?

EDIT THE LIST OF ARGUMENTS OF THE CURRENT ROUTINE WHILE IN DEBUG MODE.

ADD AN ACTIVEX CONTROL TO A WORKSHEET.

CLICK END IN A RUN-TIME ERROR DIALOG.

ALL OF THESE ANSWERS

Which keyboard shortcut causes VBE to locate the declaration of a procedure?

CTRL+F (WINDOWS) OR COMMAND+F (MAC)

ALT+F (WINDOWS) OR OPTION+F (MAC)

SHIFT+F2

SHIFT+F3

You have several variables to display on a user form, and there are too many variables to display at once. Which control best enables the user to see all the variables?

LISTBOX

MULTIPAGE

TABSTRIP

FRAME

Your Name: (required)
Your Email: (required)
Skype Username:
Exams you want to pass:

Exam Type:	VBA MCQ Skill Test
Questions Type:	Multiple Choice Questions
Total Questions:	31
Time Limit:	30 Minutes
Last Update	June, 2025

Pass VBA Exam

VBA Quiz