Thursday 15 November 2012

Debug a Macro Using Step Mode

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer or View tab.  
           Click the Macros button.
Click the Developer or View tab.  Click the Macros button.
Click the macro you want to debug. Click Step Into.
Click the macro you want to debug. Click Step Into.
The Microsoft Visual Basic window opens.
The Microsoft Visual Basic window opens.
Click the Debug menu, and then click Step Into to
 proceed through each action.
Click the Debug menu, and then click Step Into to proceed through each action.

No comments:

Post a Comment