Activating the VBE

When you're working in Excel, you can switch to the VBE by using either of the following techniques:

In addition, you can access two special modules as follows. (These special VBA modules are used for event handler procedures, which I describe in Chapter 19.)

What's New in the VBE?

Excel 2007 has dozens of significant new features, including a brand-spanking-new user interface. If you're expecting new things in the VBE, you're out of luck. The Excel 2007 VBE is exactly like the Excel 2003 VBE.

■ Right-click a sheet tab and choose View Code (this takes you to the code module for the sheet).

■ Right-click a workbook's title bar and choose View Code (this takes you to the code module for the workbook). If the workbook window is maximized in Excel, the title bar is not visible.

Figure 7-2 shows the VBE. Chances are that your VBE window won't look exactly like the window shown in the figure. This window is highly customizable - you can hide windows, change their sizes, dock them, rearrange them, and so on.

^h#nuipiui wt p

hilfbM

Vb i JH v*- *

-f

Shrtv« fn* TT—

4M*

■ . * ■

Ml - hi -¿ft

J J *£. b S 'i m

_ -J, A- jf J! J

-

mmttm

H-fcM.

- -

• ! «1 OM1 (J: ■.,

¿Mil

I *

<1

*

Figure 7-2: The Visual Basic Editor window.

Figure 7-2: The Visual Basic Editor window.

0 0

Post a comment