Thread: drop down list that i can also type regular text in as well
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default drop down list that i can also type regular text in as well
If the dropdown list was created by using Data Validation, you can go to
the Error tab in the Data Validation dialog box, and remove the check
mark from 'Show error alert after invalid data is entered'


Joyce wrote:
I want to be able to choose from options in a drop down and if not in the
drop down be able to type in another a different text.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote