VBA Error window has changed - no more Debug button

[mcomp72]

I'm not sure how or when this happened, but the look of the VBA error windows I receive has changed. I've created an image to show you what they looked like before, and what they look like now.

This is a big problem, because when my code has an error, I can no longer use the Debug button to take me to the line where the error occurred.

I have been working on my Macro-Enabled workbook for several months now, and it did not use to do this. I have no idea what I did to change the way the errors look. As a test, I tried a new workbook, and the error on that one looks the way it should (like the BEFORE image), so it doesn't seem to be a change in Excel itself.

I also tried my workbook on another computer, and the same problem occurred. So I'm guessing there is something in my code that is causing this? I have no idea what it might be. Anyone have any ideas?

 

[mcomp72]

JoeMo, how do you have it set in VBE -> Tools -> Options -> General? Do you have Break in Class Module selected?

 

[Fluff]

So that looks like it has fixed my problem! Thank you!!

Glad we could help & thanks for the feedback.

I think that if you use either "Break on all errors" or "Break in class module" it should work.

 

[JoeMo]

In the VB editor select tools > options > General > Break in class module > OK.

Do you now get the "Normal" dialogue box?

Fluff, are you indicating that the "Break in class module" button should be filled? Its not for me and I get the "Normal" dialog boxes.

 

[JoeMo]

JoeMo, how do you have it set in VBE -> Tools -> Options -> General? Do you have Break in Class Module selected?

See post #33

 

[Fluff]

Joe
Do you have it set on "Break on all errors" or "Break on unhandled errors"?

 

[JoeMo]

Joe
Do you have it set on "Break on all errors" or "Break on unhandled errors"?

It's been set on "Break on unhandled errors" from the start of my sometimes futile attempt to learn VBA.

Another good catch Fluff - thanks!

 

[Fluff]

In that case my "fix" maybe wrong, if i run this from a sheet module

Sub Test()

Dim r As Range
r = ThisWorkbook.Sheets("Sheet1").Range("A1")

End Sub

with it set on "Break on unhandled errors" I don't get the debug button.

 

[mcomp72]

In that case my "fix" maybe wrong, if i run this from a sheet module

Sub Test()

Dim r As Range
r = ThisWorkbook.Sheets("Sheet1").Range("A1")

End Sub

with it set on "Break on unhandled errors" I don't get the debug button.

Interesting. That is the same thing that had been happening to me, and I had mine set on "Break on unhandled errors", too. So I guess when you have it set that way, it is normal behavior for Excel? I had never noticed an error window without the Debug button before (other than a 400 error), so I was concerned that something had gone wrong with my workbook.

 

[Fluff]

Not sure if it's normal behaviour, as I've used "Break in class module" for years, so never had the problem.
It might always have been like that, or it might be that something has changed.

 

[JoeMo]

In that case my "fix" maybe wrong, if i run this from a sheet module

Sub Test()

Dim r As Range
r = ThisWorkbook.Sheets("Sheet1").Range("A1")

End Sub

with it set on "Break on unhandled errors" I don't get the debug button.

Hmm, I get the debug button if I run that from a selection_change sheet module, or a standard module with the "Break on unhandled errors" setting. XL2010, Win10.