2 Attachment(s)
Userform Dependent List Boxes
Hi,
I created a template about dependent listboxes on the userform and wanted to share it.
Attachment 27767
Even if the data and product categories are sorted mixed, data are grouped according to the selection from first listbox with dependent list boxes and fast results are obtained.
1 Attachment(s)
Userform Dependent List boxes
SamT,
Thank you for the advice. I have inserted and updated the file and code, but am stuck on the first item. I named the sheet GC and copied the 'Public Property' code to the sheet. I am a little confused on how to call out the array and the headers. How does the subsequent code now which column is which? Do I need to set each column as a range? Not quite understanding how GETLIST in the combo box code knows which data to use. Can you expand on that? I've imported and updated all the code on the userform as well.
File for Reference: Attachment 28566
Thanks