I am attempting to populate a second combobox with information that has been filtered from a selected value within the first combobox.
So far... I've been unsuccessful.
Private Sub Owner_afterupdate()
With Range("a:a", Range("a4:a" & Rows.Count).End(xlUp))
.AutoFilter 1, Owner.Value
Dim LastRow As Long
LastRow = .Range("B" & Rows.Count).End(xlUp).Row
FacilityID.RowSource = .Range("B2:B" & LastRow)
Formatting tags added by mark007