Thread: Drop Down Lists: Allow option of adding own data if not in drop do
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Drop Down Lists: Allow option of adding own data if not in dro
This setting does not alter the display of validation lists.

If this post helps click Yes
---------------
Jacob Skaria


"ruperthouse" wrote:

Thank you for quick response. If I use data validation and untick this, how
to I get the drop down arrow to show?

"Jacob Skaria" wrote:

From menu DataValidationData Validation windowError Alert tab uncheck
'Show error alert'

If this post helps click Yes
---------------
Jacob Skaria


"ruperthouse" wrote:

I would like to create a drop down list for user to select from but also
allow them the choice of typing in their own data if the item they want is
not in the list. Is that possible?
Reply With QuoteReply With Quote