Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Validation List AutoFill | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |