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

Richard

Check and make sure the Insert/Scroll Lock is not on.

HTH
Mark.

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

"NoodNutt" wrote:

Richard

Check and make sure the Insert/Scroll Lock is not on.

HTH
Mark.

I'm having this same exact problem. Way to annoy the hell out of
developers

On Aug 17, 9:54*pm, RichardM140
wrote:
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

"NoodNutt" wrote:
Richard

Check and make sure the Insert/Scroll Lock is not on.

HTH
Mark.