VBA Auto correction Issue

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
 
R

RichardM140

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top