macro & combobox

[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!

 

[Tom Ogilvy]

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.