Master VBA Debugging in 20 Minutes

[@Excelmacromastery]

Enjoy the video. You can download the workbook I used in the description below. Let me know the most useful thing you learned from this video.

[@ChristinaFranziska]

Thanks for the great input! very valuable. Just, I can't download the file through the link given in the description. Can anyone assist? Thanks :-)

[@outby50]

Great intro. (In decades of using VBA, I'd never pondered what Set next statement even meant. Too soon old, too late smart.) Two comments:
1) the advantage of Run to cursor vs setting a breakpoint is you don't have to clear the breakpoint afterwards if you don't want to keep stopping there during this session.
2) I'm somewhat surprised you never mentioned the Immediate window. Some of the things you showed for watch are occasionally better suited to Immediate (i.e., ? x+7700). Also, Immediate allows you to modify variable values on-the-fly (i.e., loopcount=maxloopcount-1). Not to mention Debug.Print...

[@tristanc6967]

So much great information in just 20 minutes. I'll definitely rewatch this a few times, but this will help me save so much time debugging. Thanks Paul!

[@jimfitch]

Wow, Paul! I’ve been debugging the hard way for so long … like using a hand shovel when a bulldozer is right there. Thank you!

[@Excelmacromastery]

You're welcome Jim

[@simplejuan]

Thank you for this video. I've been missing a lot of things in debugging my vba. This is very helpful. Breaking in a loop is awesome. I have been struggling with that. Now I know how. Thanks again

[@Excelmacromastery]

You're welcome

[@stevegarwood3840]

This is great. I've also been exploring the usefulness of debug.assert to stop when a value doesn't match what's expected. Not sure if there's any advantage over a watch.

[@rahul7rock]

Yet another helpful masterpiece. Sir, Thank you for this wonderful explanation. I am still learning excellent VBA tricks from you. It's Awesome.

[@Excelmacromastery]

Thanks Rahul

[@KM-co5mx]

Thank You! Knowing how to debug is just as important as knowing how to code.

[@Excelmacromastery]

Very true!

[@ricardoantunes9134]

Thanks for sharing these very useful tips!! It will help me a lot

[@Excelmacromastery]

You're welcome

[@junkertom7766]

Thanks for this video. For me it didn't contain much new stuff, but I recommend this video all the time to VBA beginners: friends, colleagues and on Stack Overflow.

[@Excelmacromastery]

Thanks for sharing!

[@freeliberalminds]

Great VBA knowledge sharing sir Paul. So much thankful. God bless you.

[@WordBaron]

The "Break When Value Is True" Watch option is especially valuable. Thank you!

[@Excelmacromastery]

Thanks Walter

[@grandpizzaplus]

Thank you for the real world example. It helped me to get a better understanding how to apply this.

[@bydlosith]

I wish I watched this video couple months ago, but only hours of painful debugging made me look for it :) thanks!

[@wayneedmondson1065]

Thanks Paul. Great, as always! Thumbs up!!

[@rafaelsilvareghin2017]

wow, I've been debugging for years and still learned a lot from your video, ty

[@Excelmacromastery]

You're very welcome Rafael!

[@joaocustodio2094]

And once again I left with more knowledge of vba. Thanks Paul.

[@Excelmacromastery]

My pleasure!

[@munshirasimraja5713]

Wonderful lesson of debugging code.
I am very grateful for the video.
Thanks u

[@jerzykepinski]

Thanks man!

[@SimpleExcelVBA]

I didn't think I could get anything new from the video, but... this 'Add Watches & Break if True' is really cool tip. Thank You for that :)
Maybe I have something for You - do You know that You can manually move the yellow line (break mode) some lines further or before? It helps me a lot in debugging.

[@Excelmacromastery]

Glad it was helpful!

[@kentokawaguchi8210]

Great and knowledgeable video. Thanks for making it and sharing it with us.

[@buzan.untung]

Thank you

[@donuteater]

Gracias, aprendi cosas nuevas

[@renyongsun9102]

Unbelievably informative video! Thank you for making it!

[@Excelmacromastery]

You're welcome

[@Pedritox0953]

Awesome video!

[@Excelmacromastery]

Glad you enjoyed it

[@ryanmattson1546]

Thanks for the video. Very helpful!

[@KaiWeissmann]

Thanks a lot for the great content!

[@Excelmacromastery]

You're welcome.

[@pegwinn]

Thank you. I am not an excel pro. So when my simple macros break it is traumatic to say the least. I appreciate your tutorial videos.

[@Excelmacromastery]

Glad you like it.

[@vishicha]

Great video, thanks for sharing your knowledge.

[@laurie93001]

I'm relatively new to vba and self taught, I often read that "call" is depreciated and "application.run" should be used instead? What are the advantages and disadvantages of each?

[@Excelmacromastery]

Call is not required but I like using it as it makes the code a little bit more readable.

[@johnwayne8059]

Nice Video Mr. VBA!👍👍👍🤟😎

[@Excelmacromastery]

Thanks John.

[@m_marcamo]

Really usefull, thanks Paul

[@Excelmacromastery]

You're welcome

[@peajayjay3622]

Excel Macro Mastery...I need help! I have been running into a brick wall concerning PasteSpecial x1PasteValues error. How do I correct this error? If you've explained this specific example, please please point me to your video. Thanks!!

[@alializadeh8195]

Thanks

[@WordBaron]

Do you have any examples where a function can be used in the "Break When Value Is True" Watch option is used? I'm trying to figure out where in my code a particular data connection is getting inadvertently moved/renamed which causes subsequent data refresh steps to fail. I created a function that should tell me if the Connection exists but adding it to the watch window [via something like ConnExists("Connection Name")] always shows "" and I wasn't sure if something like a function that returns a Boolean could be used in a "Break When Value Is True" watch option. 🤔

[@Excelmacromastery]

I don't think you can do that with a function. If possible you could return the function to a variable and put the watch on that.
Another idea is to use the Debug.Assert line which will pause if the condition is false. See this video for more about Debug.Assert(th-cam.com/video/CT7XkPXKVFw/w-d-xo.html)

[@artistryartistry7239]

1:27 I wrote the code exactly as you did. Whenever I try to step through windows just gives me an error chime. Any ideas please?

[@xs6819]

Well how do you step on I cant even get the yellow arrow to highlight the next line?

[@gopikasnair2813]

Useful❤😂

[@mrCetus]

Yet another helpful masterpiece. Sir, Thank you for this wonderful explanation. I am still learning excellent VBA tricks from you. It's Awesome.

[@Excelmacromastery]

You are most welcome