| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING
I wish to select a name from a data validation list by using the first letter
of the name so I don't have to scroll down to the name, is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING
You can get what you're asking for
....BUT not actually using DV ....and it may not be worth the effort. See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal10.html I hope that helps, -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Bellyjean" wrote in message ... I wish to select a name from a data validation list by using the first letter of the name so I don't have to scroll down to the name, is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Complete a select from a data validation list | Excel Discussion (Misc queries) | |||
| Data validation, select from list: omit blanks? | Excel Discussion (Misc queries) | |||
| Using a 'Select' (Data Validation) List? | Excel Worksheet Functions | |||
| data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
| How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
