Results 1 to 2 of 2
Thread: ComboBox/UserForms (Excel 2002)
2004-05-06, 22:24 #1
- 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?
2004-05-06, 22:58 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 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.