I filling my combo box with data from my worksheet "DDM" column A:A
When click on my command button CB1 I can only make it open 1 worksheet or all of the worksheets
How do I code it to open the selected work sheet in the combobox (cmboKB)
Thank you
Here is the code I'm struggling with
When click on my command button CB1 I can only make it open 1 worksheet or all of the worksheets
How do I code it to open the selected work sheet in the combobox (cmboKB)
Thank you
Here is the code I'm struggling with
Code:
Private Sub CB1_Click()
With Me.CB1
If ListIndex > -1 Then 'Test if anything is selected from the combobox
Sheets("LShape").Visible = True
Application.Goto Sheets("LShape").Range("v24") 'Combobox value is the worksheet name
Else
MsgBox "No model selected. ", vbExclamation, "Invalid Selection"
End If
End With
Unload Me
End Sub