Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VBA Auto correction Issue

3 views
Skip to first unread message

RichardM140

unread,
Aug 15, 2008, 7:14:12 PM8/15/08
to
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

NoodNutt

unread,
Aug 15, 2008, 7:50:04 PM8/15/08
to
Richard

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

HTH
Mark.


RichardM140

unread,
Aug 17, 2008, 10:54:08 PM8/17/08
to
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

H3adache

unread,
Sep 24, 2008, 4:33:41 PM9/24/08
to
I'm having this same exact problem. Way to annoy the hell out of
developers

On Aug 17, 9:54 pm, RichardM140

0 new messages