kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Code:
ComboBox1.List = Application.WorksheetFunction.Transpose(ThisWorkbook.Names("MyRange").RefersToRange)
Hi and hello to you all. It's been a while since I visited this site.
I am doing well and hope you are too.
I have a challenge here with me.
The above line is what I am using to fill my combobox currently.
The named range "MyRange" is from B4 to last used cell in same column. I am using a dynamic named range for that and it's working great.
The goal now is to only load part of the data from column B into the combobox.
Combobox2 will determine what I will load into combobox1.
Column C contains item categories like x y z. They are sorted so items are grouped.
And those items are loaded into combobox2.
So when I select x in combobox2, then my combobox1 should load only items from column B with x category.
Thanks