LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Structured Reference auto-completion not working completely? SVanDee Excel Discussion (Misc queries) 0 February 20th 10 01:01 AM
Auto-Completion on Drop-Down Lists A.Chase Excel Discussion (Misc queries) 2 November 4th 09 03:58 PM
Screen Tip/Auto Completion For UDFs FARAZ QURESHI Excel Discussion (Misc queries) 1 March 7th 09 06:43 AM
auto completion anirban Excel Discussion (Misc queries) 5 January 19th 09 11:23 PM
radiobuttons switch with space Courage Excel Programming 2 May 12th 04 10:36 AM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"