Change Drop Down List to Input Cell

[Legacy 436357]

Hello,

I have a cell that uses data validation with a drop down list. Is there a way through VBA to allow an entry other than what is in the list?

Thank you

 

[Fluff]

No need for VBA, in the Dv select the Error Alert tab & uncheck the "Show error alert" box

 

[Legacy 436357]

Thanks that does get rid of the message but there is VBA in place to restrict to the list.

 

[Fluff]

Then remove the code

Not quite sure why you need VBA to do what a DV does anyway.