Excel VBA snapping back my space bar action

Question

This is a weird question, but I could not formulate the question properly in Google.

When I write comments in Excel-VBA, it for some reason snaps back my cursor on all space bar hits.

Example:

Dim Arr() As String 'This is |<-- When I hit the space bar, I expect the cursor to be here.

But if I am not quick enough, it snaps it back to 'This is|<-- Here

This is really bothering me because I have to constantly go back and forth in putting spaces in my lines of text that are space-less.

Some behavior: When type really fast, I think I am able to overshoot(?) the replacement, and it doesn't snap it back, but if I go slowly, it is faster than me. Also, if I hit space, it snaps back, I hit space, it moves the cursor, and now only after a 0.5 second delay it snaps it back again.

I have Excel 2010.

Anyone else had the same issue, or know how to fix it? It isn't a big thing, it is just annoying.

Answer 1

This likely wasn't the original issue, but for anyone else with this incredibly frustrating problem who also happens to use OneDrive - my problem was simply that a workbook I had open while I was editing VBA in my PERSONAL.XLSB was stored in a OneDrive directory. Once I moved it out of OneDrive, I stopped having the issue.

To determine this, I found that one particular workbook was causing the issue once the other answers didn't work for me, so I copied just the sheet I needed to a new workbook and saved. When this didn't work, I copied values+formatting to a new workbook and saved. When that didn't work, I copied just values to a new workbook and saved. Then, when I was just about to pull out what little remaining hair I have left, I copied the original offending file out of my OneDrive directory. And...voila.

Answer 2

Turn on design mode in the developer tab.