View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Christine Christine is offline
external usenet poster
 
Posts: 147
Default Running a macro when selecting an item in a drop-down list

Beautiful! Thank you very much, Jim.

"Jim Thomlinson" wrote:

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