totn Excel 2011 VBA Debugging

MS Excel 2011 for Mac: VBA Debugging Introduction

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

What is VBA's Debugging Environment?

Microsoft Excel

In Excel 2011, 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.