View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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