Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoSelect? in Drop Down List Box
I am trying to create an invoice template and added a drop down list
box in the description field to provide valid available product description to select from to avoid typing. Problem that I am having is that this only allows me to select description by scrolling down in the list box. I would like to be able to type first couple of letters and have the cursor move down to the correct section to make selection quicker and easier specially since I will have approx 500 different description to pick from.... Would greatly appreciate any assistance with this request. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoSelect? in Drop Down List Box
Data validation doesn't support autocomplete. If you can use
programming, there's a sample file here that provides a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal10.html Amean1 wrote: I am trying to create an invoice template and added a drop down list box in the description field to provide valid available product description to select from to avoid typing. Problem that I am having is that this only allows me to select description by scrolling down in the list box. I would like to be able to type first couple of letters and have the cursor move down to the correct section to make selection quicker and easier specially since I will have approx 500 different description to pick from.... Would greatly appreciate any assistance with this request. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list of a drop down list | Excel Worksheet Functions | |||
Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |