156 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL
The Visual Basic Editor
Coding in VBA is simplified by an interface called the Visual Basic Editor (VBE).
VBA code can be written, stored, run, and debugged from the VBE. To access the
VBE go to Tools, Macro, Visual Basic Editor or use the ALT-F11 keyboard shortcut.
The VBE will open in a separate window and should appear as in Figure 10.1.
The Menu Bar
The general menu bar features recognizable commands such as File and Edit;
however, most of the options within each command will seem strange to a new user.
For now look at the Standard Toolbar that should appear as a default setting.
The Standard Toolbar has a few buttons that will be useful for the basic
operation of the VBE. Keep in mind the following buttons, which can be seen in
Figure 10.2:
■View Microsoft Excel: Jumps back to the Excel workbook
■Run Sub/UserForm: Runs the code currently selected
■Break: Breaks the code currently being run
■Reset: Resets the code after a break has occurred
■Object Browser: opens the library of VBA objects
FIGURE 10.1 The Visual Basic Editor (VBE).
