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?

 

[DanteAmor]

The error is because you are doing a division by 0. But that says the message, to review it, you could put your complete code.

 

[JoeMo]

I'm not sure how or when this happened, but the look of the VBA error windows I receive has changed.
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?

Does this change apply to all run time errors or just to the division by zero error? I think the latter error has always resulted in the message box you show in your OP.

 

[JLGWhiz]

I think it might be because the error is generated by Excel rather than VBA. But as @DanteAmor says, you can open the vb editor with Alt + F11 and step through the code to see where the condition was created. Most likely where you used vba to enter a formula in a cell.

 

[mcomp72]

Those screenshots were not actually from my computer. I found them on the web. They are not actually the error I am experiencing right now. I just used them in my post to show what was happening.

The one I am experiencing at the moment is this:

This error most certainly used to not appear this way. I have seen this error dozens of times in the old window with the Debug button. No idea why it no longer will do that.

 

[JoeMo]

Those screenshots were not actually from my computer. I found them on the web. They are not actually the error I am experiencing right now. I just used them in my post to show what was happening.

The one I am experiencing at the moment is this:

This error most certainly used to not appear this way. I have seen this error dozens of times in the old window with the Debug button. No idea why it no longer will do that.

Does this happen with one specific procedure only? And, what version of Excel are you using?

 

[mcomp72]

No, it does not happen in one specific sub. I just tried putting in code that would create an error into several different subs across different sheets. Each time, the error looked like that.

I am running Excel 365 on Windows 10.

Just to be clear, this is the actual error I am dealing with right now, and here's how it used to look, and how it looks now.

 

[mcomp72]

I just tried it on a Mac, running Excel 365. Same problem there. It's got to be something with my specific workbook, right? But what it might be, I haven't a clue.

 

[ZVI]

This can be just a msgbox, like this:

Sub Test()
  On Error Resume Next
  Err.Raise 91  '<-- Error 91 simulation
  If Err Then MsgBox Err.Description, vbExclamation + vbMsgBoxHelpButton
End Sub

1. Check your code on presence of such a MsgBox with vbMsgBoxHelpButton
2. If not found then use VBE - Tools - Debug to find syntax code issue

 

[mcomp72]

Hi ZVI. I'm not sure I understand what you're saying. But I did what I think you're suggesting.

I searched my entire project for "vbMsgBoxHelpButton" but it was not found. So there does not appear to be any code in my file similar to what you've posted.

In ran Debug -> Compile from the VBE, but it did not find any problems.