Drop Down Lists: Allow option of adding own data if not in drop do

  • Thread starter Thread starter ruperthouse
  • Start date Start date
R

ruperthouse

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?
 
From menu Data>Validation>Data Validation window>Error Alert tab> uncheck
'Show error alert'

If this post helps click Yes
 
Thank you for quick response. If I use data validation and untick this, how
to I get the drop down arrow to show?
 
Just disable the error alert.

Select the cell with the drop down list
Goto Data>Validation>Error Alert tab
Uncheck: Show error alert after invalid data is entered
OK
 
This setting does not alter the display of validation lists.

If this post helps click Yes
 
Jacob and Biff have given you the solution.

Just be aware that using this method does add the new item to the source
list.


Gord Dibben MS Excel MVP
 
Correction

"does NOT" add the item.


Gord

Jacob and Biff have given you the solution.

Just be aware that using this method does add the new item to the source
list.


Gord Dibben MS Excel MVP
 
Back
Top