Читать книгу Excel Macros For Dummies онлайн

43 страница из 60

In this chapter, you take your first look behind the curtain to explore the VBE.

The VBE is actually a separate application that runs when you open Excel. To see this hidden VBE environment, you need to activate it. With Excel open, one of these two ways does the trick:

 Press Alt+F11.

 Click the Visual Basic button on the Ribbon’s Developer tab.

To return to Excel, press Alt+F11 or click the Close button in the VBE.

Figure 2-1 shows the VBE with the key parts identified. Chances are your VBE program window won’t look exactly like what’s shown in Figure 2-1. The VBE contains several windows and is highly customizable. You can hide windows, rearrange windows, dock windows to the main window, and so on.

ssss1 The VBE with significant elements identified.

The VBE menu bar works just like every other menu bar you’ve encountered. It contains commands that you use to do things with the various components in the VBE. Many of the menu commands also have shortcut keys associated with them, such as Ctrl+G to show the Immediate window and Ctrl+R to show the Project Explorer.