macro & combobox

  • Thread starter Thread starter pandino
  • Start date Start date
P

pandino

Hello,
I have a worksheet containing some data in 1st column. In
1st cell of 2nd column I have a combobox (the input range
is on a different sheet in same workbook). I'd like to
fill active cell (selected from remaining cells of 2nd
column) chosing an item from this combobox. How should I
make a macro to do this?
Thanks for support!
 
for an activeX combobox:
Private Sub Combobox1_Click()
ActiveCell.Value = Combobox1.Value
End Sub

There are three types of comboboxes - you need to say which type. If Data
validation, it doesn't work that way.
 
Back
Top