Recap : VBA Basic Training

Which one is not allowed when naming your macro?

• Number

• Special Character

• Underscore

Macros saved in Personal Workbook can solely be used in a specific file where it's saved in.

• True

• False

It is required to indicate Description when recording a macro.

• True

• False

To undo the changes made via macro, you should:

• Click Ctrl + Z

• Click Ctrl + Y

• Create a separate macro to undo changes

You can access the recorded macros via:

Select all that apply.

• Developer tab

• Clicking Alt+F8

• Visual Basic Editor

This is where the code goes when recording a macro

• Module

• Tool Bar

• Project Explorer

This is where a hierarchical list of the projects and all of the items are

• Module

• Tool Bar

• Project Explorer

Shortcut for opening Project Explorer

• Ctrl+R

• Alt+F8

• Alt+F11

Shortcut for opening Visual Basic Editor in Excel

• Ctrl+R

• Alt+F8

• Alt+F11

When the text in the VBA code is red, it means

• Comment

• Wrong code

• Function Procedure