In the Worksheet Module:
(Data Validation List) cell is E5


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$5" Then
Application.Run Target.Value
End If
End Sub


--
HTH
Roger
Shaftesbury (UK)



"pvdalen" wrote in message
...
Hi all,

Forgive me if this turns out to be too easy, but I've a
nice, little macro that runs based on the value in a cell
from a drop down box. Right now, one has to select the
value, then run the macro. I'm sure there's a way to run
the macro from the drop down selection, but I just can't
figure it out.

Any help would be greatly appreciated.

Thanks a bunch,
Paul