Debug Code in Excel VBA

Home/Excel VBA/Debug Code in Excel VBA

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.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

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:




Displays Properties Window


Run/Execute the Active Procedure


Step By Step Debugging

Shift +F8

Execute the calling procedure in one step


Toggle Breakpoint


Clear all breakpoints


Quick Watch


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

By |March 3rd, 2013|Excel VBA|2 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).


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

    Excellent website for Excel VBA!

    This page 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:

    • PNRao November 10, 2013 at 1:32 AM - Reply

      Thanks Joe, changed it!


Leave A Comment

Related pages

vba programming languageexcel unprotect sheet password removersort worksheets alphabeticallyhow to lookup in excelexcel activeworkbook saveasunprotect excellms excel 2010 password protecthow to protect a column in excel 2007formula for finding average in excelsimple vba code for excelhow to build excel dashboardsql questions and answers for written testvba countifsexcel 2007 userformexcel vba tutorascending order on excelvba integer to stringvba character codesexcel templates with macrosexcel macro range cellsaverageif excel 2013bar of pie excelvba excel beginnersdelete duplicates in excel 2003excel mysql connectionsql query in excelthe vlookup functionexcel 2007 dashboard exampleshow to add developer tab to ribbon in wordexcel vba copy rangeoffset vbavba workbook objectfont color excel vbaworksheet activatevisual basic programing exampleshow do you remove duplicates in excelunhide multiple sheetsexcel vba write to access databaseaccess vba sql selectvba directoryadd the developer tab to the ribbon on wordloops excelvbinformation vbadashboard reports in excelproject schedule template xlsexcel vba pastevba excel examplehow to enable data analysis in excel 2007arrange numbers in ascending order in excellearn to code vbaexcel macro usesexcel sendmailexcel vba copy range to another sheetvba function tutorialisna excel functionvba programming for beginnerscombining data from multiple worksheetspivot table descending ordervba excel select workbookenter vbaincrease column width in excelvba excel subweekly task planner templateexcel embedded chartaccess parameter query vbavba excel open excel filems sql interview questions and answers pdfvlookup in excel tutorialmacro code in excelwhat is a pivot table in excel 2013excel macro close excelvba userforms addexcel 2010 column widthaccess vba date formathyperlink in vbahow to colour duplicates in excelexit do while loop vba100 most frequently asked interview questionsactiveworkbook saveasexcel vba cells value