5 Replies Latest reply: Feb 2, 2010 4:35 PM by Michael_T RSS

    Getting a Sheet to Load With "At Least One Selected"

    Michael_T

      Hi,

       

      I have a document with multiple sheets. Every sheet has the same list box, titled "SubRegion". When one particular sheet (Sheet "A") is clicked on, I need for 'always one selected value' to be selected in the SubRegion list box (or a macro with similar function). When I leave Sheet A and go to Sheet B, I need to be able to clear the SubRegion value, but not until I exit Sheet A.

      Any clue on how to do this? Thanks in advance.

       

      -Michael