#1
|
|||
|
|||
Using a dropdown list
I want to use a dropdown list for repetitive data entered in some cells, but I also want to be able to make entries that are not on the list. How do I do that?
Thank you... Janice |
#2
|
|||
|
|||
With dropdown list are you refer to Data Validation List? I.e.:
When you define Data Validation List for cell/range (from menu: Data>Data Validation, and then selecting List for Allow field and enter the comma separated list of allowed values, or a reference formula to range on same sheet or to a any Named Range, into Source field), on Error Alert tab you can use Style field to determine how the cell/range reacts on entries not in defined Data Validation List. The default value is Stop, which blocks any entries not in list. Selecting Warning or Information instead do allow such entries. For any of those selections, you can define what error message is displayed when a value not in list is entered, and a title for this error message. |
#3
|
|||
|
|||
Thank you so much... Problem solved
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selection of a dropdown creates another dropdown wih the list | krishnamurthy.ka2810 | Word VBA | 1 | 04-26-2018 11:44 PM |
Dropdown list with values | pgwatt | Excel | 6 | 10-24-2016 03:48 PM |
Dropdown list for Images? | JakeLRL | Word VBA | 3 | 04-07-2016 02:57 AM |
Help!! Dropdown List | christo16 | Word | 1 | 06-29-2015 05:18 AM |
Dropdown list, Macro | shield5 | Excel Programming | 7 | 10-27-2013 01:51 AM |