Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    412
    Thanks
    39
    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).

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    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
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •