Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2004
    Thanked 0 Times in 0 Posts

    ComboBox/UserForms (Excel 2002)

    I have several UserForms in a project I'm creating. Each of these has a MultiPage on it. I'm using a ComboBox control on one of the pages that has a list of the other UserForms, and when I select one of the forms from the drop-down list, it properly jumps to the correct form. The form it jumps to has another ComboBox, with yet another list of the UserForms, so that they can all be connected with a click. The problem is, it's difficult to go back and forth between the same two forms. When I jump back to the first form, the selection for the form I just jumped from is highlighted, and when I click it, it won't go back to the form I just came from. It 'sticks' to it somehow, sort of disabling it. Any ideas?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: ComboBox/UserForms (Excel 2002)

    Problem is that the On Click event of the combo box only fires if the selection has changed. You might set the combo box to "" after jumping to another form, so that the user is forced to make a new selection after returning.

Posting Permissions

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