Allow list OR custom text?

[Dan]

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

 

[T. Valko]

Just use the data validation list but disable the error alert.

Data>Validation>Error Alert tab
Uncheck: Show error alert....

 

[Dave Peterson]

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]

Haha - thanks! Can't believe I missed that!

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.