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

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

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

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