Populate a Cell Based on Combo Box Selection

[Davis10]

When a number is selected in a combo box I need that to populate a cell on another worksheet. Currently I have:

Private Sub ComboBox1_Click()
ComboBox1.Value = Sheets(Sheet1!F2).Value

End Sub

but this is not working. Is there any other way to do this in VBA?

 

[rob.barnes01]

Not a VBA expert by any means, but try:

Sheets("Sheet1").Range("F2").Value = ComboBox1.Value

Hope this helps.

 

[Davis10]

This works great!