Autocomplete doesn't function properly

[John]

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]

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


Autocomplete only seems to function if there are not a lot of row
between

the active cell and the matching text (all rows above the active cel are
non-blank). For example, if there are a dozen or so rows between th 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 mus type
more characters for autocomplete to complete your text. If there ar several
hundred nonblank cells between the active cell and your matching text,
autocomplete ceases to function. Any one know a workaround?

 

[Dave Peterson]

Maybe using Data|Validation or even a combobox from the Control Toolbox
toolbar???

 

[Dave Peterson]

ps. Data|Validation won't allow autocomplete, but you could pick from a list.

Comboboxes from the control toolbox toolbar do allow autocomplete.