MS-Excel / General Formatting

Displaying the Visual Basic Editor

To get the Visual Basic Editor onscreen in any Office program, choose Developer, Visual Basic. The new window that appears (although bear in mind that the window you see may be slightly different).

You can also get to the Visual Basic Editor by pressing Alt+F11. In fact, this key combination is a toggle that switches you between the Visual Basic Editor and the current Office program.

[Previous] [Contents] [Next]

In this tutorial:

  1. Writing Your Own Macros
  2. Activating the Ribbon's Developer Tab
  3. Displaying the Visual Basic Editor
  4. Touring the Visual Basic Editor
  5. Understanding VBA Procedures
  6. Creating a Command Macro
  7. Entering VBA Statements
  8. Creating a User-Defined Function
  9. Understanding User-Defined Functions
  10. Writing a User-Defined Function
  11. Using a Function
  12. Advantage of VBA IntelliSense
  13. Shutting Down the Visual Basic Editor