Run 1 macro when any item from listbox is selected

Originally Posted by marreco

Hi.
Try
considering that the listbox is linked in cell E5

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$E$5" Then

'Your Code Here

End If

End Sub

It worked like a charm, thanks!