That didn't quite answer my question but it did clear up some issues. (e.g.
if I have car registration numbers in the combo box, and have the rest of the
data for the cars like make, model and engine size elsewhere in the workbook,
I want the correct details to appear in the cells I want when I select any
one of the car registration numbers).

"Tom Ogilvy" wrote:

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.