for a combobox from the control toolbox toolbar,
Link the combobox to the cell where you want the value to appear.

Right click on the combobox in design mode and select properties. Use the
linked cell property with an argument like

Sheet1!B9

--
Regards,
Tom Ogilvy


"Addz" wrote in message
...
Hello

I'm trying to get some data to be synchronised with some data in a combo
boxes, (e.g. when I select an item from the combo box I want the correct
value/answer for it to be displayed in one of the cells).
Plz help as I'm pretty new to all of this.