| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown List That Accepts Other User Input
Thanks Gord. This does the work I need and I have also bookmarked the site
you suggested for future reference. "Gord Dibben" wrote: Yes. Uncheck "Show error alert" The user-input will not be added to the list permanently. If you want that you will require some VBA code. See Debra Dalgleish's site for a sample workbook. http://www.contextures.on.ca/excelfiles.html#DV0012 Gord Dibben MS Excel MVP On Sat, 3 Apr 2010 16:00:01 -0700, GEdwards wrote: I cannot find if there is a way to have a dropdown list that contains pre-defined data validation entries and also allow a user to input their own. Is there a way to do this in Excel? . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging values from a list, based on user input | Excel Worksheet Functions | |||
| Prompt user for input and utilize that input | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| Make input in one column determine dropdown list in another. | Excel Discussion (Misc queries) | |||
| How to make an input in one column determine dropdown list in anot | Excel Worksheet Functions | |||
Threaded Mode
