combo box as cell reference? how?
 

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...


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=546054

combo box as cell reference? how?
 

Here are two ways


Private Sub ComboBox1_Change()

ActiveCell.Value = ComboBox1.Value 'one way

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