Microsoft Office Tutorials and References
In Depth Information
Working with Visual Basic Editor
✦ Split bar: This tool divvies up the screen for you. Drag the Split bar
down to separate the Code window into two independently scrollable
panes. Drag the Split bar back to the top of the scroll bar to unsplit the
✦ Procedure view: When clicked, the window displays only one procedure
(or the declarations section) at a time. This feature is useful when you’re
scrolling through a long procedure and don’t want to scroll past the end.
✦ Full Module view: When clicked, the window lets you scroll through all
the declarations and procedures in the module. This feature is useful
when you’re browsing through a module.
✦ Sizing handle: Drag it to size the window. (You can drag any corner or
edge as well.)
Using the Immediate window
The Immediate window (or debug window) in Visual Basic Editor allows
you to run code at any time, right on the spot. Use the Immediate window
for testing and debugging (removing errors from) code. If the Immediate
window isn’t open in VBE, you can bring it out of hiding at any time by
choosing View ➪ Immediate Window.
When the Immediate window is open, you can anchor it to the bottom of the
VBE window just by dragging its title bar to the bottom of the VBE window.
Optionally, you can make the Immediate window free-floating by dragging its