kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
I have five comboboxes in all.
One named cmbMain
The other four, cmb1 to cmb4
CmbMain is loaded with five items.
When I select the first item from cmbMain, I enable only cmb1.
When I select the second item, I enable both cmb1 and cmb2.
When I select the third and fourth items, I enable cmb1, cmb2 and cmb3.
When I select the fifth item, I enable all from cmb1 to cmb4.
Cmb1 to cmb4 are loaded with same items, say A, B, C, D.
My goal is to be able to avoid selecting same item in multiple comboboxes.
Can someone pull it up for me?
I can't seem to figure it out.
One named cmbMain
The other four, cmb1 to cmb4
CmbMain is loaded with five items.
When I select the first item from cmbMain, I enable only cmb1.
When I select the second item, I enable both cmb1 and cmb2.
When I select the third and fourth items, I enable cmb1, cmb2 and cmb3.
When I select the fifth item, I enable all from cmb1 to cmb4.
Cmb1 to cmb4 are loaded with same items, say A, B, C, D.
My goal is to be able to avoid selecting same item in multiple comboboxes.
Can someone pull it up for me?
I can't seem to figure it out.