How to Debug Macros in Excel 2004 for Mac

It takes only a few minutes to use VBA in Excel 2004 to debug macros.

Users of Excel 2004 on Mac systems can easily script and edit macros using Visual Basic for Applications -- or VBA -- within Microsoft Office. While later versions of Excel use Applescript to replace the functions of VBA, the 2004 version allows users to easily create, edit and debug macros in Excel. VBA is a valuable tool for getting the most out of this program. Debugging the macro, to ensure it runs properly, is a somewhat simple process thanks to VBA.

Things You'll Need

• Microsoft Excel 2004 for Mac
• Computer running Mac OS X

Instructions

1. Start Excel so that only the workbook containing your macro is open. From the Tools menu, click on "Macros."

2. Click on the macro you wish to edit, in the ensuing dialog box. Click on the "Design" icon, which can be found in the toolbar as an icon with a triangle and pencil.

3. Click on the "Single Step" icon button in the toolbar. Or go to the "Debug" menu and click on "Step." The toolbar button looks like four or five lines, with a looping arrow at the top of the icon box.

4. Click on the "Run" button in the toolbar or menu. In the toolbar, this appears as an icon with an exclamation point. VBA will begin to go through the macro, line by line, to review the code and highlight any errors.

References

• Macworld: Office 2011...The Macro Is Back
• Microsoft: How to Create a Personal Macro Workbook in Excel for Mac
• Microsoft Office: Find Problems in a Macro