EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Ozgrid, Experts in Microsoft Excel Spreadsheets

Debug Excel VBA Macro Code

 

Got any Excel Questions? Excel Help

No matter how good we become at writing VBA code, debugging is a fact of writing code. Even when our macros return no Runtime errors, we should TRY and force potential code errors.

BREAKPOINT

Example Of Breakpoint in VBA Code
A selected program line at which execution automatically stops.

To add a breakpoint click the right grey margin within the Procedure at the point the execution should stop.

DEBUG RUNTIME ERRORS

Example of a Runtime Error that requires debugging
Example of a Runtime Error that requires debugging


To quickly debug macros place your mouse insertion point anywhere in the Procedure and step-through using F8. Each line will be highlighted yellow as you step through. You can make changes and then drag the yellow highlight up/down to repeat/ommit lines.

After hitting debug the offending line is highlighted yellow
After hitting debug the offending line is highlighted yellow


You can hover your mouse pointer over variables, range objects etc and see their values.

Hover over Range Object and we can see A1 is text NOT a date
Hover over Range Object and we can see A1 is text NOT a date

 

Drag the yellow debug highlight up and fix code, then run again
Drag the yellow debug highlight up and fix code, then run again

 

Adding If IsDate to check cell data type fixes degbug error
Adding If IsDate to check cell data type fixes degbug error

Also see Immediate Window, Watch Window or Locals Window in the VBA help.

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates