How do I code a command button to open a worksheet based on an Item selected in a combobox

[wstring]

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

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

 

[Fluff]

In that case it needs to be

With Me.CmboKb

 

[wstring]

Ok that makes sense thank you for your time

 

[Fluff]

You're welcome