Data Validation Lists

[Silena K-K]

Hi All

I want to create a data validation list which allows the user to select
either an option in the list or allows them to enter they own data. Is that
possible?

Thanks for your help, Silena

 

[Debra Dalgleish]

In the data validation dialog box, go to the Error Alert tab
Remove the check mark from 'Show error alert after invalid data is entered.'
Click OK

 

[Silena K-K]

Thanks Debra - that's excellent!!

In the data validation dialog box, go to the Error Alert tab
Remove the check mark from 'Show error alert after invalid data is entered.'
Click OK