Microsoft Office Tutorials and References
In Depth Information
Introducing the Visual Basic Editor
Displaying Excel’s Developer tab
The Excel Ribbon doesn’t display the Developer tab by default. If you’re going to be working with
VBA, it’s essential that you turn on the Developer tab:
Right-click the Ribbon and choose Customize the Ribbon.
Excel displays the Customize Ribbon tab of the Excel Options dialog box.
In the list box on the right, place a checkmark next to Developer.
After you perform these steps, Excel displays a new tab, as shown in Figure 7-1.
Figure 7-1: By default, the Developer tab is not displayed.
Activating the VBE
When you’re working in Excel, you can switch to the VBE by using either of the following
h Press Alt+F11.
h Choose Developer ➜ Code ➜ Visual Basic.
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.)
h Right-click a sheet tab and choose View Code, which takes you to the code module for
h Right-click a workbook’s title bar and choose View Code, which takes you to the code
module for the workbook. If the workbook window is maximized in Excel, the workbook
window’s 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.