View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Need to have a dropdown list or allow other entry?

Select the cell, then select Data Validation. Set up the List-based
validation, then go to the Error Alert tab. Uncheck the box marked 'Show
error alert after invalid data is entered' OK.

Hope this helps,

Hutch

"Vera" wrote:

Hi,
I'm working with Excel 2003 and I need a cell to have a dropdown list to
choose from and allow people to type something different. When I use the
data validation tool, it will only allow what's in my list. Any other method
to get a dropdown list and allow a different entry?

Thanks for all your hard work!
Vera