I am populating a combobox from a list via VBA where Columns A and B are data and Column C holds a 1 or 0, with 1 being active. Only active data will populate the combobox. I can achieve this via a loop, but it seems more efficient to enter the entire array into memory, filter it, then populate the combobox with the filtered list. However, I cannot determine how to filter the list in memory. Can someone help?
Set vRng = s1.[A1:C6] vArray = Filter(vRng, "1") s1.Test() = vArray
Bookmarks