Linking control Combo Box.one changes trigger same changes to other

Hi,

i have 2 sheet in same workbook,both contain the control combo box to select city.
Function :
1. if a user select city DELHI in comboxbox 1,same should be reflected in Combobox 2 in sheet2
2. if a user then made a change of city in combo box 2 sheet 2 ,it should reflect the change in combox1 in sheet1

basically whatever city he choose in one of the combox box,it should reflect in all other combo boxes

Goggle searched it a lot,not able to find anyhelp


thanks

thanks for the reply,
i am using Active X list combo Box.i will try this.
currently i did

Please Login or Register  to view this content.

the above code shows 2 comboBox .but i am using 5 comobox for a project,so it takes time because each change in Combox trigger 4 other combox change and so on...