Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$A$2" Then 'one of the DD cells
'do your stuff
ElseIf Target.Address = "$A$5" Then 'other DD cells
'do other stuff
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"pikapika13" wrote
in message ...

I have two drop downs: one selecting month, and the other a year. I
would like it when one of these changes, it runs a macro. Sounds
simple...but I could not get anything successfully done.

Any help is much appreciated!


--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile:
http://www.excelforum.com/member.php...o&userid=10892
View this thread: http://www.excelforum.com/showthread...hreadid=557898