Running a macro when selecting an item in a drop-down list
Right click the workhseet tab with the drop down in it and select view code.
Paste the following...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$H$4" Then Call MyMacro
End Sub
--
HTH...
Jim Thomlinson
"Christine" wrote:
Could someone provide me with the code to run macro "MyMacro" when an item is
selected from a drop-down list located in cell H4?
Chris
|