Copy text from a List box to a Cell!

[Patrick Molloy]

assign a macro to the list box's change event that simply
copies the listbox's linked cell to the selected cell...

Sub DropDown1_Change()
Selection.Value = Range("N6").Value
End Sub
In this sprocedure, N6 is the listbox's linked cell. when
a valuie in the list is selected, the macro is called and
hte value copied from N6 to the selected cell.

If you used the ActiveX listbox, then you'd do it simply
from the obnject's change event....
Private Sub ComboBox1_Change()
Selection = ComboBox1.Value
End Sub


Patrick Molloy
Microsoft Excel MVP

 

[Tom Ogilvy]

In this sprocedure, N6 is the listbox's linked cell.

Sub DropDown1_Change()
Selection.Value = Range("N6").Value
End Sub

this would copy the listindex, not the selected name.