I have a combo box, when I make a selection in the combobox it filters the selection in the listbox but I want it to list Column B & C data - it only lists column B data. I did make the column count 2
![]()
Private Sub ComboBox8_Change() Dim rng As Range UserForm2.ListBox1.Clear For Each rng In Range("B3:C3", Range("B3:C3").End(xlDown)) If rng.Offset(, -1) = Me.ComboBox8.Value Then UserForm2.ListBox1.AddItem rng Next rng End Sub
Bookmarks