MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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