Combo Box Userform Selection To Open 2nd Combo Box

[wpjensen]

Macro Help
I have a Combo box Userform with selection A B C D dropdown. Want to be able to select any (in this example) B that opens a 2nd Combo Box Userform with all B's display., then able to select one from the B List

I have the 2 boxes working as desired but can't get the first box to select the appropriate (in this case B) in the 2nd Combo Box Userform.


Private Sub ComboBox1_Change()
Select Case ComboBox1.Value

Case "A"
ComboBox2.DropDown

Case "B"

Case "C"

Case "D"

End Select

End Sub



Private Sub Label1_Click()

End Sub

Private Sub UserForm_Initialize()

ComboBox2.AddItem "A"
ComboBox2.AddItem "B"
ComboBox2.AddItem "C"
ComboBox2.AddItem "D"

End Sub


Would also like some help on a macro for OK & Cancel button

Not sure whether I have explained this good enough, been working on this for a couple of weeks learning VB as I go

Wayne <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->