Excel VBA / Is it possible to make a ComboBox-dropdown with a branching structure/feature?

[Young Grasshopper]

Hi World,

I would like to have a listbased combobox that works in a branching/hierarchy sort of way.. meaning that if you click on the combobox and hoover down to say, the 2th option, a new list opens to the right, with index's grouped underneath the 2th option.

The list will need to repopulate everytime it's activated, so i think it would have to be a VBA ComboBox.

I'm adding a picture from the toolbar of notes, so it's a little more clear what i'm picturing in my head

Would this be possible?
Would appreciate any help

 

[James006]

Hi,
You request is pretty much Standard .... dependent drop-down lists
e.g. see : Dependent Drop-Down Lists

 

[Young Grasshopper]

Ah, cool!
Would it be possible to do the same with one combobox that "branches" out, instead of multiple drop-downs as the link suggests?

 

[James006]

Following your explanation, it seems to me you could be potentially interested in a different approach : a Treeview

Using a Treeview Control

This is a tutorial on the creation of a simple Treeview control on an Excel userform. For the purposes of this example, we'll be populating the Treeview control with worksheet names and the addresses of cells with formulas in them. … Continue reading →

excelguru.ca