I came across a wonderful framework for creating dependent combo boxes using class collection, where each class has an array. Ref: Dependent ComboBoxes with arrays in class collection| Excel VBA (sitestory.dk).
I am wanting to expand this framework to create 5 levels of cascading, assuming that...
Hi There,
I have a form with two combo boxes. The First is named cboxNoSpeeds (and the user can choose 1 or 2 for the number of speeds value) and the second is named cboxHP1 (and the intent is for the user to be able to select all the horsepower values that have the corresponding speed value...
Hi, first I want to thank you in advance for helping me out.
I have developed a user form in excel. I have 2 combo boxes. The first one is Manager and the second one is Employee. Upon form initialize I populate all Managers and Employees from excel tabs with the code below (this populates...
Hi, first I want to thank you in advance for helping me out.
I have developed a user form in excel. I have 2 combo boxes. The first one is Manager and the second one is Employee. Upon form initialize I populate all Managers and Employees from excel tabs with the code below (this populates...
I'm trying to setup multiple cascading comboboxes in a userform. I've been able to get combobox2 to show the relevant managers for the selected entity in combobox1 (example: if I select Entity 4 (in combobox 1), it should display Apple and Cash & Equivalent in Combobox2). However, I would like...
Hi,
I have a problem that I have not been able to solve. I am trying to create a list that cascades in a way similar to the windows start menu. I have read a number of posts on this forum about dependent lists, and have not been able to find the answer I am looking for.
If I am...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.