Primer on Debugging, Error Handling, and The VBA Editor

[Zydeceltico]

Hi All -

I am finding that I have a tremendous deficit with knowing how to debug, utilize error handling, and the generally get around and use the VBA editor.

Tutorials? Books? Website?

Thanks a bunch!

Tim

 

[jdraw]

See these links

http://www.cpearson.com/Excel/ErrorHandling.htm
http://www.cpearson.com/Excel/DebuggingVBA.aspx

You an Google vba extensibility for various materials on the vba editor.
Here is one https://www.bettersolutions.com/vba/visual-basic-editor/extensibility.htm

Steve Bishop has a youtube series on vba here.

Good luck.

 

[theDBguy]

Hi All -

I am finding that I have a tremendous deficit with knowing how to debug, utilize error handling, and the generally get around and use the VBA editor.

Tutorials? Books? Website?

Thanks a bunch!

Tim

Hi Tim. Some more links available at UtterAccess.

 

[Zydeceltico]

Thanks Guys

 

[Uncle Gizmo]

I did some YouTube videos on error handling in 2007! The videos are on my website here:- http://www.niftyaccess.com/error-handling-ms-access/

I was using an older version of MS Access, which does not create macros when you use a wizard to create a command button, it actually created VBA code, along with error handling code. I think I need to update them!

 

[swell]

Debugging VBA has been a major weakness in my knowledge. Thank you all for these links.