Hi Ajgoodson

You can use DataValidation to create the list
http://www.contextures.com/xlDataVal01.html

Then you can use the Change event to do what you want
http://www.cpearson.com/excel/events.htm

Example for cell A1

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A1"), Target) Is Nothing Then
'call your macro here
End If
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ajgoodson" wrote in message ...
I have a list that I want to make into a drop down list that when each
individual item is selected, cause a macro to run. Can anyone assist?