Prev: "fixed objects will move" warning
Next: Updating another workbook
From: John on 5 May 2010 07:58
Autocomplete only seems to function if there are not a lot of rows between
the active cell and the matching text (all rows above the active cell are
non-blank). For example, if there are a dozen or so rows between the active
cell and the matching text cell, autocomplete works fine. If there are, say
50 rows between the active cell and the matching text cell, you must type
more characters for autocomplete to complete your text. If there are several
hundred nonblank cells between the active cell and your matching text,
autocomplete ceases to function. Any one know a workaround?


From: Dave Peterson on 5 May 2010 09:22
Maybe using Data|Validation or even a combobox from the Control Toolbox
toolbar???


John wrote:
>
> Autocomplete only seems to function if there are not a lot of rows between
> the active cell and the matching text (all rows above the active cell are
> non-blank). For example, if there are a dozen or so rows between the active
> cell and the matching text cell, autocomplete works fine. If there are, say
> 50 rows between the active cell and the matching text cell, you must type
> more characters for autocomplete to complete your text. If there are several
> hundred nonblank cells between the active cell and your matching text,
> autocomplete ceases to function. Any one know a workaround?

--

Dave Peterson
From: Dave Peterson on 5 May 2010 09:23
ps. Data|Validation won't allow autocomplete, but you could pick from a list.

Comboboxes from the control toolbox toolbar do allow autocomplete.

John wrote:
>
> Autocomplete only seems to function if there are not a lot of rows between
> the active cell and the matching text (all rows above the active cell are
> non-blank). For example, if there are a dozen or so rows between the active
> cell and the matching text cell, autocomplete works fine. If there are, say
> 50 rows between the active cell and the matching text cell, you must type
> more characters for autocomplete to complete your text. If there are several
> hundred nonblank cells between the active cell and your matching text,
> autocomplete ceases to function. Any one know a workaround?

--

Dave Peterson
From: aflatoon on 5 May 2010 08:32

Autocomplete only kicks in when there is a unique match in the list to
what you have typed. Are you sure it's not that behaviour that you are
seeing? (the more entries you have, the more likely it is you have to
type more characters to get a unique match).



J
o
h
n
;
7
1
6
7
2
1

W
r
o
t
e
:


>
Autocomplete only seems to function if there are not a lot of rows
between
> the active cell and the matching text (all rows above the active cell
are
> non-blank). For example, if there are a dozen or so rows between the
active
> cell and the matching text cell, autocomplete works fine. If there are,
say
> 50 rows between the active cell and the matching text cell, you must
type
> more characters for autocomplete to complete your text. If there are
several
> hundred nonblank cells between the active cell and your matching text,
> autocomplete ceases to function. Any one know a workaround?


--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: http://www.thecodecage.com/forumz/member.php?u=1501
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=200690

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: "fixed objects will move" warning
Next: Updating another workbook