How switch off space auto-completion in VBA editor?

carl.w...@gmail.com

unread,

Jun 12, 2007, 8:55:07 AM6/12/07

to

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

Gary Keramidas

unread,

Jun 12, 2007, 9:03:55 AM6/12/07

to

unless i don't understand what you're pointing out, auto-complete isn't done
until i press enter on my pc.

--

Gary

<carl.w...@gmail.com> wrote in message
news:1181652907.9...@j4g2000prf.googlegroups.com...

carl.w...@gmail.com

unread,

Jun 12, 2007, 9:26:13 AM6/12/07

to

Hi Gary,
that's the point, auto-completion is done immediately in my VBA
editor, before I hit return! What is strange is that on some rare
opportunities I have the wonderful world that you live in, auto-
completion only after return.

It seems like another instance of applications changing what I input,
when I do NOT want it, like in MS Word if you start typing in an empty
document and it starts to auto-change all different kinds of things...

-- Carl

On 12 Juni, 15:03, "Gary Keramidas" <GKeramidasATmsn.com> wrote:
> unless i don't understand what you're pointing out, auto-complete isn't done
> until i press enter on my pc.
>
> --
>
> Gary
>

> <carl.wilk...@gmail.com> wrote in message

> > -- Carl- Dölj citerad text -
>
> - Visa citerad text -

Gary Keramidas

unread,

Jun 12, 2007, 9:31:07 AM6/12/07

to

try excel in safe mode and see what happens

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /s

if you're using office 2003.

--

Gary

<carl.w...@gmail.com> wrote in message
news:1181654773.0...@x35g2000prf.googlegroups.com...

carl.w...@gmail.com

unread,

Jun 12, 2007, 10:20:00 AM6/12/07

to

Interesting! The immediate auto-completion seems to revert to the
wanted auto-completion at return when I run in safe mode.

In my normal mode I have some 6-7 add-ins running -- could it be them
that are fiddling around with settings? If so, I wonder if there
exists some global settings file with settings that have precedence
over the add-ins, because I need the add-ins to do my work.

-- Carl

On 12 Juni, 15:31, "Gary Keramidas" <GKeramidasATmsn.com> wrote:
> try excel in safe mode and see what happens
>
> "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /s
>
> if you're using office 2003.
>
> --
>
> Gary
>

> > - Visa citerad text -- Dölj citerad text -

Gary Keramidas

unread,

Jun 12, 2007, 11:06:59 AM6/12/07

to

yes, hold down the shift key as you click to open excel and the add-ins should
not load.

--

Gary

<carl.w...@gmail.com> wrote in message
news:1181658000.3...@d30g2000prg.googlegroups.com...

carl.w...@gmail.com

unread,

Jun 12, 2007, 12:24:04 PM6/12/07

to

Ok, thanks Gary, will try that. And is there any way to override the
auto-complete settings that my add-ins have created, i e can I have
the add-ins loaded AND then in some way change the auto-complete
setting to only auto-complete at return? Of course one wants the best
of two worlds at the same time (and I need the add-ins)...

-- Carl

On 12 Juni, 17:06, "Gary Keramidas" <GKeramidasATmsn.com> wrote:
> yes, hold down the shift key as you click to open excel and the add-ins should
> not load.
>
> --
>
> Gary
>

Gary Keramidas

unread,

Jun 12, 2007, 1:20:09 PM6/12/07

to

don't know. if this works, then you'll have to disable each add-in one by one to
find the culprit.

--

Gary

<carl.w...@gmail.com> wrote in message
news:1181665444.3...@r19g2000prf.googlegroups.com...

almurray

unread,

Nov 21, 2009, 2:51:00 PM11/21/09

to

To prevent auto-complete from working without pressing Enter, please switch on 'Design Mode'.

I had the same problem as you and this solves the annoyance just fine.

:)

carl.wilken wrote: