Excel VBA Technology & Digital Applications 3

Question 1

Which VBA property of the Application object returns the version number of Excel currently running?

Accepted Answer

Application.Version

Answer

Application.Version returns a string like "16.0" representing the Excel version, useful for writing version-conditional code.

Question 2

In VBA, what does the Shell function return when it successfully launches an external application?

Accepted Answer

The process ID of the launched application

Answer

Shell returns the process ID (a Double) of the program it started, or zero if the call failed.

Question 3

Which event fires when a workbook is opened and is the correct place to initialize application-level settings in VBA?

Accepted Answer

Workbook_Open

Answer

Workbook_Open is the standard event procedure in ThisWorkbook that runs automatically when the file is opened.

Question 4

What VBA technique allows you to respond to events raised by objects not natively supported by the class module?

Accepted Answer

WithEvents keyword in a class module

Answer

Declaring an object variable with WithEvents in a class module allows VBA to sink and respond to that object's events.

Question 5

When automating Outlook from Excel VBA, which object is the correct entry point to the Outlook object model?

Accepted Answer

Outlook.Application

Answer

Outlook.Application is the top-level object that provides access to all other Outlook objects such as NameSpace, Folders, and MailItem.

Excel VBA Practice Test