To Step into a Macro (VBA/ActiveX)

As a macro is being executed, you have the option to evaluate each line of code one at a time.

  1. On the ribbon, click Manage tab Applications panel Run VBA Macro.
  2. In the Macros dialog box, Macros In drop-down list, select the project file you want to work with.
  3. In the Macros list, select a macro and click Step Into.

    On the Debug toolbar or Debug menu, click Step Into to continue the execution of the macro one line at a time. Click Continue to resume normal execution of the macro.