View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Dropdown List That Accepts Other User Input

Yes, change the Error Alert to Information.



--
Regards
Dave Hawley
www.ozgrid.com
"GEdwards" wrote in message
...
I cannot find if there is a way to have a dropdown list that contains
pre-defined data validation entries and also allow a user to input their
own.

Is there a way to do this in Excel?