| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| option panes/ drop down lists | Excel Discussion (Misc queries) | |||
| Adding to drop down lists | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
Hybrid Mode
