Visual Basic Editor Problems

Question

This problem with the Visual Basic editor began two or three updates ago (about a week to ten days ago):

As I am typing a line of code, the line updates and causes the cursor to jump to the left (or end of the line to jump right, past the cursor) so that typed characters go into the wrong place; space I type are automatically removed before I can type the next word in the line; After successfully completing a line, I hit Enter, the line first updates causing the end of the line to jump to the right of the cursor so that the line breaks before the end and triggers a syntax error popup. On creating a Sub or Function, the update-while-typing generates the bracket set before I'm done typing, again causing characters to go into the wrong place.

I installed the latest updates of Operatiing System—Currently MacOS Big Sur Version 11.6.4— and of Microsoft Office 365. Still the problem persisted. restarting the computer did not help.

I experimented with different configurations of editor preferences, and none corrected the problem. At one point I thought that the absence of the RibbonX_Code module in my Project Modules was to blame. I put one there and for a brief time that seemed to work, but it didn't. Within minutes the problem was back.

I am fairly certain this problem was generated by a recent update to the Microsoft 365 software. Can you fix it?

Answer 1

Hi

If you test an old build and the problem goes away, it points to a problem with the new build of Excel. If the problem remains, something else changed on your system in the interim.

Answer 2

Thanks. I will see if I can do that—It would be my first time and I'm concerned about losing new files or changes to old ones. Need to back everything up first, I would assume.

I did delete Office 365 and re-install it with no effect on the problem. The new installation contained all but the latest update (Update 5), but the problem existed before Update 5.