How to Get to VBA in Excel 2007
The 2007 edition of the Microsoft Excel spreadsheet program added several extra features and streamlined many of the menu screens. Unfortunately it also hid many of the more advanced features that can confuse first time users, such as the Visual Basic for Applications (VBA) screen. If you want to use VBA code in your Excel spreadsheets you will need to change an option inside the program to be able to view the VBA menu.
Other People Are Reading
Instructions
-
-
1
Click the Microsoft Office icon at the top-left corner of the Excel spreadsheet. Select the "Excel Options" button at the bottom of the drop-down menu.
-
2
Navigate to the "Popular" tab at the left side of the window. Locate the "Top Options For Working With Excel" heading.
-
-
3
Check the check box labeled "Show Developer Tab In The Ribbon" underneath the "Top Options" heading. Click "OK."
-
4
Click the "Developer" tab at the top of the screen. Select the "Visual Basic" option underneath the Microsoft Office button to bring up the VBA screen.
-
5
Double-click the "Sheet1" entry at the left side of the VBA window to bring a blank screen. Type your VBA code into the blank area. Click on the other sheet options if you want to add VBA code to the other sheets in your Excel workbook.
-
1
Tips & Warnings
If you want to automate simple tasks with a macro instead of writing out your own VBA code, you can navigate to the "View" tab and click the "Macros" button at the right side of the window.
VBA can add extra functionality to any spreadsheet, such as creating one-click buttons that users can interact with to automate complicated mathematical procedures. If you aren't sure how to use VBA code, there are many tutorials available online (see Resources).
