#1
|
|||
|
|||
select from list and allow entry not in list
Hi All, trying to use data validation to select from a list of values for cell entry, this works ok. How can I also allow the cell to take a value not in the list without an error or other prompt telling me I can't do that or flagging an error msg in the cell.
regards Trevor |
#2
|
|||
|
|||
In the Data Validation dialogue, uncheck the box for "Show error alert after invalid data is entered"
https://www.officetooltips.com/excel...d_entries.html |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find drop down list entry with keystrokes | Empy | Excel Programming | 3 | 06-09-2018 06:10 AM |
How to select an Outlook folder from a list-box entry | kovenna | Outlook | 0 | 06-06-2018 12:33 AM |
Is there a way to select an entire list? | rocky2 | Word VBA | 3 | 03-08-2016 02:07 AM |
Win 8.1 won't allow entry from drop down list in Outlook | nphutchnson | Outlook | 0 | 10-18-2014 10:46 AM |
Autocorrect in Word not selecting proper entry from list | Llewella | Word | 4 | 05-12-2012 02:22 PM |