Drop Down Lists (XP)

Topic

New Reply

When using a drop down list for data validation, is there a way to have a default label that is “sticky”?

I know I can put an entry into the cell and a drop down label, but once the user chooses from the drop down list there is no way to go back to the original label. I’d like to be able to allow the user to see the default label, then make a choice from the list, and then if they want to undo that choice, to be able to go back to the default label (rather than to some other choice from the list).

Reply | Quote

Replies

There isn’t a way in native Excel data validation

However, there would be ways in VBA by loading and detecting a default value in the data validation values.
It would probably seriously depend on the data and how you were validating it – if you were using data validation for strings I can see easy ways – e.g. store the default value directly in the string
e.g.
one
two
three (default)
four

and then remove the (default) bit if it is selected. A global function could do ResetAllToDefault if required.

Reply | Quote

There isn’t a way in native Excel data validation

However, there would be ways in VBA by loading and detecting a default value in the data validation values.
It would probably seriously depend on the data and how you were validating it – if you were using data validation for strings I can see easy ways – e.g. store the default value directly in the string
e.g.
one
two
three (default)
four

and then remove the (default) bit if it is selected. A global function could do ResetAllToDefault if required.

Reply | Quote