You don't say whether the combo box is on a userform or a worksheet or, if
the latter, it is from the Forms toolbar or the Control Toolbox.

Assuming a Control Toolbox control on a worksheet (Sheet1):

Sheet2.Range("B2") = Sheet1.ComboBox1

--

Vasant


"Nigel Bennett" wrote in message
...
I have a combo box called city populated with a list of
cities, when I select a city I want to populate cell B2 on
sheet 2 with the value in the combo boxes, I presume it
would go in the after update of the combo box but what is
the syntax