Page 183 - Excel Data Analysis

10 537547 Ch09.qxd 3/4/03 12:13 PM Page 169

AUTOMATING ACTIONS WITH MACROS 9

For easier navigation in the Visual Basic Editor, you can
use shortcut keys. These shortcuts work when the Visual
Basic Editor window has focus, or is the selected window.
SHORTCUT KEY FUNCTION
F7 Switches to the Code window for the
object (node) that is selected in the
Project Explorer.
F4 Switches to the Properties window
and displays the properties for the
selected object.
Ctrl + R Switches to the Project Explorer.
Alt + F11 Toggles between the Visual Basic
Editor and Excel. This shortcut is useful
when trying to step through a macro.
F1 Displays online help on the item
selected in the Code window.
Shift + F2 Displays a definition of the selected
function or subroutine in the Code
window.

Calculate_Total Module1

OPEN THE VBE FROM THE ■ The Macro dialog box ■ The Visual Basic Editor ■ The module containing the
MACRO DIALOG BOX opens. displays the code for the macro is highlighted in the
⁄ Click Tools ➪ Macro ➪ ¤ Click the macro that you selected macro in the Code Properties window.
Macros. want to modify. window.
‹ Click Edit.

169