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