Microsoft Office Tutorials and References
In Depth Information
This topic focuses exclusively on VBA modules — also known as standard modules —
which is where Excel stores custom worksheet functions.
Minimizing and maximizing windows
At any given time, the VB Editor may have lots of code windows. Figure 23-9 shows an example.
Figure 23-9: Code window overload.
Code windows are much like worksheet windows in Excel. You can minimize them, maximize them, hide them,
rearrange them, and so on. Most people find that it's much easier to maximize the code window that they're
working on. Sometimes, however, you may want to have two or more code windows visible. For example, you
may want to compare the code in two modules or copy code from one module to another.
Minimizing a code window gets it out of the way. You also can click the Close button in a code window's title
bar to close the window completely. To open it again, just double-click the appropriate object in the Project win-
You can't close a workbook from the VB Editor. You must reactivate Excel and close it from there.
Storing VBA code
In general, a module can hold three types of code:
• Sub procedures: A procedure is a set of instructions that performs some action. For example, you may have
a Sub procedure that combines various parts of a workbook into a concise report.