VBA Error Debugging: How do I set a break point to do Error Testing?

G

Guest

Select "Err" (not Error, but "Err") in the procedure you want to debug. Right
click, select "Add Watch...", Select "Break when value changes", OK

Run the code. If Err changes from 0 to anything else (1004 - my personal
favorite), the VBE will appear in debug mode.

Dale Preuss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top