autofill using data validation
 

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

--
Kevin

autofill using data validation
 

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.
--
Gnothi se auton.


"Kevin" wrote:

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

--
Kevin

autofill using data validation
 

DV dropdowns to not allow autocomplete.

See Debra Dalgleish's site for instructions on how to combine DV with a Combobox
which allows autocomplete.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Thu, 22 Nov 2007 05:42:03 -0800, Kevin
wrote:

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

autofill using data validation
 

is there any way to do ti so you do not have to double click in the cell?
--
Kevin


"Gord Dibben" wrote:

DV dropdowns to not allow autocomplete.

See Debra Dalgleish's site for instructions on how to combine DV with a Combobox
which allows autocomplete.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Thu, 22 Nov 2007 05:42:03 -0800, Kevin
wrote:

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

autofill using data validation
 

As written.......no.


Gord


On Thu, 22 Nov 2007 10:56:01 -0800, Kevin
wrote:

is there any way to do ti so you do not have to double click in the cell?