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

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

How switch off space auto-completion in VBA editor?
 

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

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- Dölj citerad text -

- Visa citerad text -

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


wrote in message
oups.com...
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

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- Dölj citerad text -

- Visa citerad text -

How switch off space auto-completion in VBA editor?
 

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

wrote in message

oups.com...
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

wrote in message

oups.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- Dölj citerad text -

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

- Visa citerad text -

How switch off space auto-completion in VBA editor?
 

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

--


Gary


wrote in message
oups.com...
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

wrote in message

oups.com...
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

wrote in message

oups.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- Dölj citerad text -

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

- Visa citerad text -

How switch off space auto-completion in VBA editor?
 

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

wrote in message

oups.com...
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

wrote in message

roups.com...
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

wrote in message

oups.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- Dölj citerad text -

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

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

- Visa citerad text -

How switch off space auto-completion in VBA editor?
 

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

--


Gary


wrote in message
oups.com...
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

wrote in message

oups.com...
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

wrote in message

roups.com...
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

wrote in message

oups.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- Dölj citerad text -

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

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

- Visa citerad text -

How switch off space auto-completion in VBA editor?
 

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:

On Tuesday, June 12, 2007 8:55 AM
carl.wilken wrote:

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

On Tuesday, June 12, 2007 9:03 AM
Gary Keramidas wrote:

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

On Tuesday, June 12, 2007 9:26 AM
carl.wilken wrote:

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

On Tuesday, June 12, 2007 9:31 AM
Gary Keramidas wrote:

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


wrote in message
oups.com...
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:

On Tuesday, June 12, 2007 10:20 AM
carl.wilken 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

On Tuesday, June 12, 2007 11:06 AM
Gary Keramidas wrote:

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


wrote in message
oups.com...
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:

On Tuesday, June 12, 2007 12:24 PM
carl.wilken 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

On Tuesday, June 12, 2007 1:20 PM
Gary Keramidas wrote:

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


wrote in message
oups.com...
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/tutorials...sh-nuclea.aspx