macro & combobox
 

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!

macro & combobox
 

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.

--
Regards,
Tom Ogilvy


"pandino" wrote in message
...
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!