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...
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...
Here are two ways
Private Sub ComboBox1_Change()
ActiveCell.Value = ComboBox1.Value 'one way
Cells(1, 2) = ComboBox1.Value 'another way
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks