View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silena K-K Silena K-K is offline
external usenet poster
 
Posts: 37
Default Data Validation Lists

Thanks Debra - that's excellent!!

"Debra Dalgleish" wrote:

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html