combo box as cell reference? how?

[tweety127]

HI...
how can i use the combo box as a cell reference, so that when i choose a text from the combo box, and save it....the text on the combo box will saved on the cell specified...

[Christian]

Here are two ways


Private Sub ComboBox1_Change()

ActiveCell.Value = ComboBox1.Value 'one way

Cells(1, 2) = ComboBox1.Value 'another way
End Sub