View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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