Dependent (conditional) combo box without creating UserForm

[fariz]

Hi guys,

I will highly appreciate if you provide me information regarding Dependent (conditional) combo box without creating UserForm. I have attached sample file and need following assumptions to be done.

- When selecting continent America on 1st combo box, 2nd combo box must show USA and 3rd combo box show Washington and New-York
- When selecting continent Asia on 1st combo box, 2nd combo box must show UAE and 3rd combo box show AbuDhabi and Dubai.
- When selecting continent Europe on 1st combo box, 2nd combo box must show UK and Turkey, And 3rd combo box show London, Manchester, Newcastle, Istanbul and Ankara. In addition, when you select UK on 2nd combo box then 3rd combo box must show London, Manchester and Newcastle. when you select Turkey on 2nd combo box then 3rd combo box must show Istanbul and Ankara.

Sample file attached

Thanks in advance

[snb]

See

http://www.snb-vba.eu/VBA_Afhankelijke_Comboboxen_en.html

[fariz]

Thanks

it helps