Auto Fill (sort of)

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

I would like to designate a range of cells on a spread sheet. I would also
have a list of name somewhere. When I make one of the designated cells
active, I would like to be able to type in the first 2 letters of a name from
the list, and it would automatically complete the name. If there were more
than 1 name with those 2 letters, ie Smith, it would give me a short list of
the 2 or 3 names that fit. I don't want the data verification where there is
a down arrow, and the whole list appears, because the list is too long. Is
there any thing in Excel that would fill the bill? If not, any other ideas?

Thanks in advance
 
If you use a combo box on a userform, you have the facility that, as you
enter consecutive digits, the name will eventually be selected. So if you
have Daniel, Dawn, Dick, . . . . Donovan, Dottie, if you type in D, all the
D's will show, when you type in oall the names from Donovan will show, and if
you want Dottie, it is the next name in the list.

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top