VBA editor auto-deletes spaces at the ends of lines

editor, excel, vba

Solution

There is sort of a way to turn off the auto-"correction" in the VBA Editor.

`Tools` Menu -> `Options` -> `Editor` Tab -> Clear the `Auto Syntax Check` box

Sadly, this won't solve all your problems, as the VBA Editor tends to have a mind of its own, for better or worse.

Problem

Is there a way to convince the VBA editor in Excel to stop auto-formatting lines to remove the space at the end when I pause in my typing for a quarter second?

Original source