With all due respect - when the OP asks [quote]:
"...and also allow a user to input their own" - I, and probably 99% of the
supporters in this D.G., would guess he DOES NOT want and/or need ANY KIND of
alert about an "Illegal Value..."
Micky


"ozgrid.com" wrote:

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?