This code populate the combo box with my list in column A. In column F has a status that is either "open" or "Closed" I will like to list only the names that are open. can someone offer assistance in revising my code. Thank you
Dim Rng As Range, LRow As Long LRow = Range("A" & Rows.Count).End(xlUp).Row cbName.Clear For Each Rng In Range("A7:A" & LRow) If Rng.Value <> "" Then cbName.AddItem Rng.Value Next