Dynamic Dependable activex combo box with vba

Hi friends,

I have to create 3 active x combo boxes, which should be dependable on each other (i.e combo box 2 should contain the list items based on combo box 1 selection, and combo box 3 should contain list items based on combo box 2 selection.)
- for combo box list generation i am supposed to use VBA code.
- List items for combo boxes should be dynamic, as it can change when user will update the data

Please find attached the test file with more sample data and details on what i am trying to do.
Dynamic Dropdown.xlsm

Thanks & regards,

Try your Returned File:-

Regrds Mick

Hi MickG, thanks a lot for your help and guidance, but there is small problem.

what if "sub group" and "country" name will change (or if number of countries will increase or decrease).
This list in the Combo box 2 & 3 are not dynamic. is there any way to make it dynamic (as the 3 variable can change if user will will update the data in table).

Try this Modified code:-
You should now be able to add new Groups , Sub Groups and Countries to rows 5,6 and 7.
Regrds Mick

Thanks a lot Mick G for the modified file. Its perfect, working smoothly.

Thanks and Regards,

You're welcome
Regrds Mick