Hi guys, am stuck somewhere, av been able to create 2 combo boxes in my form and populated the first one. my question is how can i link the two combo boxes so that the list is combo box 2 depends with the user's selection in combo box one, which fetches data from an excel worksheet.
Any help?..Thanx in ADVANCE ...
THIS IS MY CODE (for populating combo box 1)
<
- Code: Select all
Private Sub UserForm_Initialize()
Dim Rng
Rng = range(range("A1"), Cells(1, Columns.count).End(xlToLeft))
ComboBox1.List = Application.Transpose(Rng)
End Sub
>