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
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