select from list and allow entry not in list

		Microsoft Office Forums > Microsoft Excel > Excel
select from list and allow entry not in list

08-01-2018, 04:36 AM

jeffreybrown jeffreybrown is offline

Windows Vista select from list and allow entry not in list

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:12 AM.