after combobox entry show userform

[flash3000]

made a combobox with entrypossibility yes and no.
When yes is entered I want Userform1 to show up.
When no is entered I want Userform2 to show up.
Can somebody give me the full code?
What I have now is:

Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "yes"
ComboBox1.AddItem "no"
End Sub

 

[iggydarsa]

Private Sub CommandButton1_Click()
    If ComboBox1.Value = "yes" Then
        UserForm1.Show
    ElseIf ComboBox1.Value = "no" Then
        UserForm2.Show
    End If
    
    
End Sub



Private Sub UserForm_Initialize()
ComboBox1.AddItem "yes"
ComboBox1.AddItem "no"

End Sub

 

[erik.van.geit]

Hello, flash3000
Welcome to the Board !!!!!

before answering some remarques
why do you use a combobox for this ? wouldn't two optionbuttons do ?

your code will add over and over ye and no to the list
you can use

Private Sub ComboBox1_DropButtonClick()
ComboBox1.List = Array("yes", "no")
End Sub

your question

Private Sub ComboBox1_Click() 'or ComboBox1_Change
If ComboBox1 = "yes" Then UserForm1.Show
If ComboBox1 = "no" Then UserForm2.Show
ComboBox1.Clear
End Sub

using "clear" allows to select again the same value

kind regards,
Erik

 

[flash3000]

thanks guys it worked