autofill using data validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Using Data / validation I have created a list box with predefined values eg
"Kevin", "Paul", "John", "Keith".

I would like to enable an autofil feature such that if you enter the first
letter of a value in the list you can see available values. I see 2 ways it
can happen using above 4 values as example

1. If I enter "K" a drop down list appears showing "Kevin" and "Keith" and I
can arrow up down to choose. I see this a lot when selecting airports in
airline reservation websites
2. When entering letters once you get a unique possibility compared to the
list the value pops up and you can just enter eg if i type "KE", nothing but
if i enter "Kev" then Kevin is highlighted - this already happens in excel
but only if the value is already displayed in cells above ie not connected to
the values in the list

any advice welcome. I can code a little but not an expert so easiest
solution probable best, which i think is 2 but I would prefer to be able to
do no 1
 
You are correct, #2. There is another elegant and less elegant method by
taking advantage of Excel 2007's FormulaAutoComplete feature.

Name the pick list cell names as they are, e.g., Kevin for the cell
containing the "Kevin" label etc.

In the input cell, when the user types: =K, the Kevin and Keith names will
appear, when the user enters =Kei then the list narrows to Keith, press Tab
and Keith is entered.

Without VBA there are your 3 alternatives that I know of.
 
Back
Top