excel combo box opening userform ?????

[boylynch]

i have an excel sheet with a combo box containing a list of names on it. when i click on a name in the combo box i would like a specific userform to appear, this is probably a pretty basic problem but i would like to know how to write the code for this.

[JustinLabenne]

Assuming your combobox is from the control toolbox:

Option Explicit
 
Private Sub ComboBox1_Change()
 
    Select Case ComboBox1.Value
    
        Case "MyForm"
            UserForm1.Show
            
        Case "YourForm"
            UserForm2.Show
            
        Case "ThisForm"
            UserForm3.Show
            
    End Select
    
End Sub

[boylynch]

thanks very much justin but the combobox isnt from the control toolbox, its a different type of combobox

[boylynch]

its an excel drop down list box, i think its of the type made with data validation, not quite sure.

[JustinLabenne]

If it's validation

Option Explicit
 
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> Range("C1").Address Then Exit Sub
 
    Select Case Target.Value
        Case "Userform1"
            UserForm1.Show
        Case "Userform2"
            UserForm2.Show
        Case "Userform3"
            UserForm3.Show
    End Select
End Sub

[boylynch]

I think that could be it, ill work on it and reply in the meantime.