3 Tips for VBA Macro Debugging in Excel (+ Bonus Tips)

A real-world example of how to debug your macros to figure out what is causing an error - this is especially helpful for hard-to-find errors that don't stop your macro from running.

These tips all work together to save you time when debugging your code or just when you want to figure out why it is outputting unexpected results.

In this debugging example, the VBA code I cover is a moderate level example that includes loops, IF statements, a worksheet function, and in-line error handling.

#msexcel #vba #tutorial

[kromeface]

I'm glad Bane took the time to show us this, very thoughtful of him.

[sbatsia]

This is a G-R-E-A-T tip for debugging. Thank you so much.

[jackscopilot]

These are great tips! I always learn so much from your videos.

Some feedback though: not sure if this is a repost but the audio is not great. It makes it hard to listen and follow along. Very muffled.

[Onestepcloserrightpath]

Great but u showed an error with the variable but then u said there is no error ythat’s why it didn’t go into iserror? I am confused

[DoOver]

Good video, but really need to work on the audio quality. Was difficult to hear.

[artistryartistry]

My dude, you have to do quality control on your audio. This sounds terrible which is distracting and undermines the intent of the video. I appreciate the willingness to help people, but the quality control is lacking.