Use the View Toolbars command to work with VBE toolbars. VBE toolbars work just like those in Excel: You can customize them, move them around, display other toolbars, and so on.
The Standard toolbar, which is directly under the menu bar by default (see Figure 3-1), is one of four VBE toolbars available. The VBE window is your customizable friend. You can right-click virtually anything in the VBE and get a shortcut menu of common commands. You also find that many of the menu commands have shortcut keys associated with them. It contains commands that you use to do things with the various components in the VBE. The VBE menu bar, of course, works like every other menu bar you’ve encountered.
I discuss these additional components in both Chapter 13 and in Part IV. This window is highly customizable - you can hide, resize, dock, rearrange, and so on in the window.Īctually, the VBE has even more parts than are shown in Figure 3-1. Because so much is going on in the VBE, maximize the window to see as much as possible.Ĭhances are your VBE program window won’t look exactly like the window shown in Figure 3-1. Understanding VBE componentsįigure 3-1 shows the VBE program window, with some of the key parts identified. To do this, choose Tools Macro Visual Basic Editor. You can also activate the VBE by using menus within Excel. The quickest way to activate the VBE is to press Alt+F11 when Excel is active. You can’t run the VBE separately Excel must be running in order for the VBE to run. By seamlessly, I mean that Excel takes care of opening VBE when you need it. The Visual Basic Editor is a separate application where you write and edit your Visual Basic macros. In this chapter, you find out how to work with the VBE, and get down to the nitty-gritty of entering VBA code. Now it’s time to expand your horizons and explore an entirely new aspect of Excel: the Visual Basic Editor (VBE). It’s an experienced Excel user, you know a good deal about workbooks, T \ formulas, charts, and other Excel goodies. Understanding three ways to get VBA code into a module Discovering the Visual Basic Editor parts
0 kommentar(er)
