How switch off space auto-completion in VBA editor?
unless i don't understand what you're pointing out, auto-complete isn't done
until i press enter on my pc.
--
Gary
wrote in message
ups.com...
Dear all,
this seems like an embarrassingly simple question to ask -- but this
is driving me crazy.
The VBA editor auto-completes with spaces code that is entered, the
problem is that it does so *without* moving the cursor correspondingly
to the end of the line.
Assume I would want to write
"x=5/b+a".
If I input
"x=5/b"
and wait for two seconds before continuing, the VBA editor auto-
completes with spaces to
"x = 5 #/ b"
BUT leaves the cursor where the #-sign is. This seems like almost a
bug, if I continue I will end up entering
"x = 5+a /a"
which is clearly not the same thing.
It is strange because mostly the auto-completion takes place
immediately (or within 2 seconds), but in some rare cases the auto-
completion takes place when I hit return, just as I want it to. I
tried to uncheck "Auto Syntax Check", but that does not solve the
problem.
Any hints on this *dearly* accepted.
Regards,
-- Carl
|