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:
How switch off space auto-completion in VBA editor?
12-Jun-07
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
Previous Posts In This Thread:
How switch off space auto-completion in VBA editor?
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
unless i don't understand what you're pointing out, auto-complete isn't done
unless i do not understand what you are pointing out, auto-complete is not done
until i press enter on my pc.
--
Gary
Hi Gary,that's the point, auto-completion is done immediately in my VBAeditor,
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:
one
Re: How switch off space auto-completion in VBA editor?
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
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:
Interesting!
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:
done
yes, hold down the shift key as you click to open excel and the add-ins should
yes, hold down the shift key as you click to open excel and the add-ins should
not load.
--
Gary
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:
Ok, thanks Gary, will try that.
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:
hould
't done
gly
don't know.
don't know. if this works, then you'll have to disable each add-in one by one to
find the culprit.
--
Gary
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:
EggHeadCafe - Software Developer Portal of Choice
Pete's Real Jewish Nuclear Bomb Holiday Chili
http://www.eggheadcafe.com/tutorial...da-26bad47324de/petes-real-jewish-nuclea.aspx