PDA

View Full Version : Not Highlighting Errors



MikeDube
10-21-2009, 08:24 PM
I'm hoping this will be my last post. It has been hard for me to diagnose errors in my code because VBA no longer highlights the errors. Did I accidentally turn off this feature? If so, is there a way to turn it back on?

geekgirlau
10-21-2009, 08:58 PM
Do you have

On Error Resume Next

anywhere in your code? If so you need to use either

On Error GoTo ErrHandler ' direct to error handling

or at the very least

On Error GoTo 0 ' show the error without handling it

Bob Phillips
10-22-2009, 12:49 AM
Sometimes it is necessary to have



On Error Resume Next


so that your code does not blow up on a predictable error, but when you do use this you should reset it as soon after as is possible