REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post
Introduction

When you are writing the program you may want to test whether particular statement is working fine. Debug Code in Excel VBA is the one of important task while writing programs, it helps you in troubleshooting your code.

VBA provides several options for debugging VBA code:

Run the Procedure

place the cursor in the procedure which you want to run and Press F5 or click on the run button. It will execute that particular procedure/macro.

Stepping through you code

Place your cursor in the procedure which you want to debug:

You can step through your code line by line by pressing F8. It will take through you by line by line and you can see the result/action of the statement wile passing that particular line.

Break Point

You can run the code from one particular statement to another By placing the Break Points. Place the cursor at the line which you want to place the Break Point and press F9, it will place the break point. if you run the code by pressing F5, it will start executing the procedure and stops at the Break Point. To toggle the break point you can press the F9 again.

Alternatively you can use stop statement in the code, if you start executing the code , it will stops at stop statement in the code.

Debug statement and Immediate Window

You can select the ‘Immediate Window’ from the View menu to see the immediate Window.

It is one of the most usefull commands in the vba debugging tasks, you can use Debug.Print statement to print the result of any variable or any text in the Immediate Window

Locals Window

You can select the ‘Local Window’ from the View menu to see the Local Window.

You can see all available variable in the procedure which you are debugging by step by step.

Watch Window

When you are stepping through the procedure You can select a variable or object and right click on it to see all properties and its values in the watch window.

You will use the above methods while debugging your program, following are few short-cut key which helps you to fasten the debugging activity:

ShortKeys

Action

F4

Displays Properties Window

F5

Run/Execute the Active Procedure

F8

Step By Step Debugging

Shift +F8

Execute the calling procedure in one step

F9

Toggle Breakpoint

 CTRL+SHIFT+F9

Clear all breakpoints

SHIFT+F9

Quick Watch

F10

Activate Menu Bar

Debug Code in Excel VBA – Screen-shot

Below is the sample screen-shot of the debugging process:
Debug Code in Excel VBA

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Categories: Excel VBATags: Last Updated: June 17, 2022

2 Comments

  1. joe November 9, 2013 at 10:32 PM

    Excellent website for Excel VBA!

    This page http://analysistabs.com/excel-vba/debug-code/ has one repeating word: “you”

    You you will use the above methods while debugging your program, following are few short-cut key which helps you to fasten the debugging activity:

  2. PNRao November 10, 2013 at 1:32 AM

    Thanks Joe, changed it!

    Regards-PNRao!

Leave A Comment