Allow list OR custom text?

D

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

T. Valko

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

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

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.
 
D

Dan

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


Dave Peterson said:
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.
Click to expand...
 
Top