| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow list OR custom text?
Hi,
Is there a way to have a cell offer both the user-selectable list similar to what is achieved through data validation as well as giving them the option to enter in their own value if none of the predefined choices fits their needs? Could this be accomplished via a custom data validation or a formal? Thanks! -Dan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Allow list OR custom text?
Just use the data validation list but disable the error alert.
DataValidationError Alert tab Uncheck: Show error alert.... -- Biff Microsoft Excel MVP "Dan" wrote in message ... Hi, Is there a way to have a cell offer both the user-selectable list similar to what is achieved through data validation as well as giving them the option to enter in their own value if none of the predefined choices fits their needs? Could this be accomplished via a custom data validation or a formal? Thanks! -Dan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Allow list OR custom text?
Plain old data|validation will work.
Show that dialog. You can choose what should happen if the user types something not on the list--stop, warning, information. You can also just uncheck that "show error alert after invalid data is entered" box. Dan wrote: Hi, Is there a way to have a cell offer both the user-selectable list similar to what is achieved through data validation as well as giving them the option to enter in their own value if none of the predefined choices fits their needs? Could this be accomplished via a custom data validation or a formal? Thanks! -Dan -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Allow list OR custom text?
Haha - thanks! Can't believe I missed that!
"Dave Peterson" wrote: Plain old data|validation will work. Show that dialog. You can choose what should happen if the user types something not on the list--stop, warning, information. You can also just uncheck that "show error alert after invalid data is entered" box. Dan wrote: Hi, Is there a way to have a cell offer both the user-selectable list similar to what is achieved through data validation as well as giving them the option to enter in their own value if none of the predefined choices fits their needs? Could this be accomplished via a custom data validation or a formal? Thanks! -Dan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
| Compare text in cell to custom text format?? | Excel Discussion (Misc queries) | |||
| Custom List | Excel Discussion (Misc queries) | |||
| Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
| Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
Hybrid Mode
