How do I copy the value of a comboBox selection to a worksheet cell.

The following does not seem to be the correct format.


ComboBox1.copy Destination:=Worksheets("sheet1").Range("A1")

Any takers?

Hi Stepdev,
Just found this forum whilst googling for some help on VBA.
Saw your post, so thought I'd reply
I have used:
Worksheets("sheet1").Range("a1").Value = ComboBox1.Value in the past. Basically select the value in the combo box and then press a command button that runs the code.
See how it goes.