totn Excel 2013 VBA Debugging

MS Excel 2013: VBA Debugging Introduction

This Excel tutorial explains the VBA debugging environment in Excel 2013 (with screenshots and step-by-step instructions).

What is VBA's Debugging Environment?

Microsoft Excel

In Excel 2013, VBA's debugging environment allows the programmer to momentarily suspend the execution of VBA code so that the following debug tasks can be done:

  1. Check the value of a variable in its current state.
  2. Enter VBA code in the Immediate window to view the results.
  3. Execute each line of code one at a time.
  4. Continue execution of the code.
  5. Halt execution of the code.

These are just some of the tasks that you might perform in VBA's debugging environment.