January 23, 2020
My question is..
With multiple forms with comboboxes & multiple sheets, I have one same task.
Task is simple...
1)Read unique values from table to Combo1
2)Loading records which belongs to Combo1 in Combo2
Task was done..but requires same code bunch of time. This is not good I think. It can be done through collection controls in one Sub only. Idea is:
Line1: If form is Abc & combo1 is selected then
Line2: Read from column from SheetAbc..
CBox & Column may change themself based on user selection in line1 & 2.
How can I loop through forms and comboboxes even with sheets colmns. Thanks
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
Please provide a sample file so we can see your data structure, it's hard to follow your description.
If you prefer a generic solution, I think you should use field and form tags to create a way to simplify coding. Use form tag to store the corresponding sheet name, then on that form fields, use field tags to indicate the corresponding columns from the sheet indicated by form tag.