I would try using the Change Event. Maybe something like this is what you
are asking for:

Sub Combox1_Change()

Select Case Combox1.Value

Case Is = "2008, Mar"
Call Macro1
Case Is = "2008, Jan"
Call Macro2
Case Is = "2007, Dec"
Call Macro3

End Select

End Sub
--
Cheers,
Ryan


"OsmoseTom" wrote:

I have a data validation list in cell B2. The list consists of two choices
(Year, Month). Based on the users selection I would like to run a macro.
The maros are named Year and Month.