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.