Excel 2016 mac VBA debug button does nothing

Question

Hi guys, I recently got a new Mac at work, had to install everything fresh, after installing Office 2016 and making sure to be up to date with all the latest updates when using the VBA editor, if an error occurs in the code I get the usual "Microsoft visual basic" popup screen with the two options "Abort" or "debug"  I have noticed that the "debug" option no longer works, no longer highlights the line of code that caused it to crash. Then I looked further and realized that I can no longer step through the code with breakpoints anymore, it ends at the first breakpoint and nothing happens when you press the next button. I have tried removing all of the Microsoft sweet and reinstalling several times.  Any ideas?

Running:

MacOS Sierra version10.12.2

Excel for mac version 15.29.1

Answer 1

Salute to you Gordon for being a Mac MVP. I admire and respect all MVPs but a lot more for you to persist with Mac.

I tried for two months and then gave up. I installed VMWare and then Windows 10 only for MS Office.

Answer 2

Hi Ryan,

Thanks for your updates.

We will check with related team, and post back if there is any update.

Thanks,

Yoga

Answer 3

Hi guys sorry for the delay, 

You are correct with the exception of the run button. I can provide an example bellow. 

The script above is designed to be very simple and show the issues, Obviously its going to overload the integer kicking back an error.  When I press run this works fine and I get the bellow error message as expected. 

Here is where things get strange, when you click debug, it should highlight in yellow the line that overloaded the variable, instead the error message goes away but the VBE window stay exactly the same. 

Next, i added a few lines for demonstration purposes. 

When you run the script with breaks again only the run button responds, when the code hits a break it rests from the start instead of waiting at that break, therefore pressing the run button repeatedly, as shown above, will print the value 1 constantly, because only the code above the break is running. 

Lastly, the buttons to the right do nothing at all, leaving no way to step through the code. 

As I mentioned I have tried completely removing all Microsoft software and supporting files and reinstalling twice with no luck

Answer 4

Hi Ryan,

Any update?

Regards,

Tisky

Answer 5

Hi Ryan,

Based on your description, we’d like to confirm the information.

Is clicking on these buttons makes no response? If so, please provide every detailed steps of your situation, some screenshots are appreciated.

Regards,

Tisky