One option is to insert a combobox from menu ViewToolbarsControlBox

--In design mode from Properties window set the property ListFillRange as
the range in which you have the names for example Sheet2!A1:A100

--and set you can link the control to a cell. Check out the property "Linked
Cell"



--
Jacob (MVP - Excel)


"Hark2k" wrote:

I have an excel file with a long list of names. We have it set up to do a
pick from list but we'd like to allow the user to type a letter and the list
will automatically skip to the names that start with that letter. For
instance, if they open like list and type "K" it will go to the list of names
that begin with K.

We are also interested in figuring out how to set up an Auto complete
function so that if the user starts typing in the persons name in the cell,
the list will narrow to only names that match the string of letters. In other
words, if the user starts to type "Jo" it will pull up Jones, Johnson and
Jonas. or if they continue to type and get to "Joh" it will leave only
Johnson.

Can anyone help me? Thanks!!!