| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - List - with "Add Items..."
To allow entry of an item that is not on the list, turn off error alert.
To permanently add items you need VBA Debra Dalgleish has a sample workbook with the code available. http://www.contextures.on.ca/excelfiles.html#DV0012 Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 09:46:01 -0700, Neon520 wrote: Hi everyone, Is there a way to do Data Validation as List, and allow the user to "Add Items.." to the list if they need to? I found this feature is available in other program, but not excel? Is there a workaround? Thank you, Neon520 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - List - with "Add Item..." | Excel Discussion (Misc queries) | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| Data Validation "List" - Setting length of list shown | Excel Discussion (Misc queries) | |||
| How do I delete items out of my "recent documents" list? | Excel Discussion (Misc queries) | |||
| Data Validation - List - Data "NOT BETWEEN" - Source Possible? | Excel Worksheet Functions | |||
Threaded Mode
