Combobox help

**Findout** · 08-21-2009, 08:47 AM

Hi,

I am fairly new to Visual basic so please excuse my ignorance.

I am trying to make a combobox in excel so that when the list drops down and I click one of the options, another combobox will display, this new combobox will drop down and once an option is chosen. I believe the term is cascading combo boxes. Below these an autoshape will appear. Each set of options will have a different set of autoshapes. If that makes sense.

Can someone please show/help me do this.

Cheers!

**Findout** · 08-21-2009, 10:05 AM

Someone help me please

**Kalyan** · 08-21-2009, 10:24 AM

Do you want to do it with Forms with VBA? It could be simpler with that approach...

**Findout** · 08-21-2009, 10:37 AM

If it would work like that then yes

**Palmetto** · 08-21-2009, 10:58 AM

See attached as a start.

Briefly:

Sheet3 contains named lists used for the comboboxes.
Sheet1 contains two comboboxes. Combobox2 list is dependent on the selection made in Combobox1.

Once selection is made in Combobox2 a shape is added. Lots more code is required to control size and location.

Please Login or Register  to view this content.

**Findout** · 08-21-2009, 11:01 AM

Thank you - very helpful.

How do I edit the what is in the combo boxes?

for example in the choose option list - change to fruit, meat, veg
and the item list - apples, etc.

and the object something I have made before e.g. a flowchart