MS-Excel / General Formatting

Activating the Ribbon's Developer Tab

If you'll be writing VBA code regularly, you can make some coding chores a bit more efficient by displaying the new Developer tab in the Office 2007 Ribbon. This tab gives you one-click access to many VBA-related features, so it's worth displaying. Follow these steps:

  1. Choose Office, Application Options (where Application is the name of the current Office program, such as Word or Excel).
  2. In the Popular tab, click to activate the Show Developer Tab in Ribbon check box.
  3. Click OK.

Note that displaying the Developer tab in one Office program displays it in all of them.

[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