In the attached:
-deleted some data from cells in column E of the Lists sheet - for demonstration.
-Added a Name in Name Manager called StoreList with the formula:
=FILTER(TC_List[TC Name],TC_List[TC Name]<>"")
In the userform:
-deleted the reference in the RowSource property of the cmbTC control
-added a UserForm_Initialize() sub which adds a .list to cmbTC, that is StoreList. (I presume the store list doesn't change while you're using the user form.)
You can do this differently:
Use the filter formula above in a cell on the Lists sheet, say cell M1
Add a Name in Name Manager with the formula:
=M1#
Use that name in the RowSource property of the cmbTC control.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote