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