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

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?

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

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?

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

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?

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

Just disable the error alert.

Select the cell with the drop down list
Goto DataValidationError Alert tab
Uncheck: Show error alert after invalid data is entered
OK

--
Biff
Microsoft Excel MVP


"ruperthouse" wrote in message
...
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?

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?

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

On the Settings tab, select List and make sure In-cell dropdown is checked.

--
Biff
Microsoft Excel MVP


"ruperthouse" wrote in message
...
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?

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

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

On Tue, 21 Jul 2009 09:13:02 -0700, 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?

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

Thanks everyone.

If I disable the error alert, I seem to lose the drop down box
"T. Valko" wrote:

Just disable the error alert.

Select the cell with the drop down list
Goto DataValidationError Alert tab
Uncheck: Show error alert after invalid data is entered
OK

--
Biff
Microsoft Excel MVP


"ruperthouse" wrote in message
...
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?

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

Correction

"does NOT" add the item.


Gord

On Tue, 21 Jul 2009 09:47:33 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Tue, 21 Jul 2009 09:13:02 -0700, 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?