Macros in Depth

When planning a macro, what is an initial best practice to evaluate the data?

Determine the best way to display the data to the user.

Which VBA code structure should be used when you want to apply a macro at least once, and continue an unspecified number of times?

Do...Until

If a file contains a macro but you are not sure, what is a best practice to handle it?

Open the VBA code and review it.

Which options from the Illustrations group can be used to run a macro?

Pictures, Online Pictures, Shapes, Icons, and 3D Models

What is a best practice to join two macros?

Place the macros side-by-side in VBA, and then remove the ending statement in one macro and beginning statement of the other macro.

What are the three default windows when entering VBA?

Project, Properties, and Code

What is valid VBA code to select a cell?

Range("B5").Select

How can the Developer tab be added to the Ribbon?

Right-click any tab, and then choose Customize the Ribbon.

When you receive the error "Cannot Edit a Macro on a Hidden Workbook Error," what should you do?

Select Alt+F11, navigate to the macro in question, and then use it. This error will appear when you want to use this macro with other workbooks and is misleading, but it can be used when we open it within the VBA window.

How is a shortcut key defined in a macro?

Select the shortcut key field, and then enter a letter

When using an IF statement in VBA, what should the statement in the "if" evaluate or return?

The IF statement will always evaluate to a true or false, and then perform the action(s) and code underneath it or not.

How can input be implemented in VBA where users can enter a value and then, based on that value, perform different actions?

Use the inputBox() method

How is the For...Next statement implemented in a macro?

by creating a macro, and then implementing the For counter statement in VBA

When should you add a macro to the Quick Access Toolbar?

when you want to use it throughout Excel

What is the difference between a Do While and a Do Until statement?

A Do While statement performs actions while the condition is true, and Do Until performs actions until the condition is false.

How many VBA actions can a macro contain?

A macro can contain at least one VBA action.

What is true about references?

Absolute references link to a specific cell and do not change when copied or filled.

How can blank rows of data be easily removed?

Highlight all data, go to Find & Select > Go To Special > Blanks, right-click in gray area, and then select Delete > Shift cells up.

When recording a macro, what should you do with the cells?

Highlight the cells to reference their placement when reusing a macro.

Prior to running a macro for the first time, what is displayed?

a warning to allow or deny the use of macros

Where is a macro recorded once saved?

in the current workbook

Which items can be entered when we record a macro?

macro name, shortcut key, Store macro location, and description

Which keystrokes can be used when creating a keystroke shortcut for a macro?

only upper- or lowercase letters

Why are MS Excel macros useful?

to eliminate repetitive actions

Why would step mode be a best practice to use when testing a macro?

to evaluate each line of code as it is processed

Why should you use a Personal Macro Workbook?

to make a macro available to all workbooks

Why would we use partial code in VBA?

to perform repetitive tasks