You want to trigger the change event something like this...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "Call your macro"
End If
End Sub

Change the $A$1 to the cell address of the cell with your validation list...
--
HTH...

Jim Thomlinson


"Modell" wrote:

I have a validation list set up as well as a macro related to the information
in that list. I want to be able to select something from the list and have a
macro automatically run.

Currently, I have a separate button that I have to push that runs the macro,
but I want to eliminate this step.