Results 1 to 2 of 2
Thread: Drop Down Lists (XP)
2004-09-21, 17:12 #1
- Join Date
- Jun 2003
- Utah, USA
- Thanked 5 Times in 5 Posts
Drop Down Lists (XP)
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).
2004-09-21, 18:41 #2
- Join Date
- Oct 2002
- Wellington, Wellington, New Zealand
- Thanked 0 Times in 0 Posts
Re: Drop Down Lists (XP)
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
and then remove the (default) bit if it is selected. A global function could do ResetAllToDefault if required.