select from list and allow entry not in list

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

FAQ

Thread Tools

Display Modes

07-31-2018, 06:44 PM

trevorc

Windows 7 32bit select from list and allow entry not in list

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

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

« Previous Thread | Next Thread »

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 03:08 PM.