another combo problem
Posted by Mike on January 18, 2002 1:58 PM
I'm making a basketball stat sheet for a little league team and I have the individual game stats, each on a different work sheet. I have a combo box that lists all the teams we play, but I don't know how to make the selection in the combo box bring me to the specific sheet that holds the game stat.
Posted by Russell Hauf on January 18, 2002 3:50 PM
Can you tell me what kind of combo box you have? Is it on a UserForm or on a sheet? If it's on a sheet, did you insert it from the Forms toolbar or the Control Toolbox?
What I would do is to use a combo box from the control toolbar. After you have assigned each sheet name to your combo box, double-click on the combo box (while still in design view). This should take you to the code window and insert the ComboBox1_Change() event. You can enter the following:
Private Sub ComboBox1_Change()
Sheets(ComboBox1.Text).Select
End Sub
Again, you need to make sure that the values in your combo box are spelled exactly like the sheets.
Hope this helps,
Russell
