| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list limit to list
How can I limit the people using my spreadsheet to the list of client names listed? My list works great, but instead of selecting Gino's from the drop down list, they type in "Ginos." I've search Data Validation and see the Warning message options, but not a limit to list option. Also, I know if I have "Gino's" in the column cell once, then the next time someone types "G" in a cell that "Gino's" will pop up. Is there a way to have this happen the first time some types a "G?" -Chuck- -- Dropdown3 ------------------------------------------------------------------------ Dropdown3's Profile: http://www.excelforum.com/member.php...o&userid=30321 View this thread: http://www.excelforum.com/showthread...hreadid=518753 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| circular drop down list on different pages | Excel Worksheet Functions | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Threaded Mode
