VBA Auto correction Issue

  • Thread starter Thread starter RichardM140
  • Start date Start date
R

RichardM140

I have Excel 2003 and the VBA editor acts oddly. It keeps deleting spaces as
I type.

For example if I type DIM MyString as String the editor will remove the
spaces as I type giving me DIMMyStringasString. I can then go back and put
the spaces and it will maintain them.

As I type I see the space on screen for a moment then the cursor backs up to
the last visible character. It doesn't really matter what I type. I can type
abc 123, but I end up with abc123.

I've tried the detect and repair for Excel. I tried turning the auto syntax
check off and on, I tried turning all options off and I've tried several
combinations of on and off, but I cannot get it to stop. The editor did not
used to do this.

Does anyone have any ideas on how to fix the problem?

Thanks,

Richard
 
Thanks for the idea, but that doesn't seem to make any difference. I just
verified it is off and I turned it on just to see if that made a difference,
it did not.

Any other thoughts?

Thanks,

Richard
 
Back
Top