View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
macgru macgru is offline
external usenet poster
 
Posts: 20
Default Running a macro based on a cells value


Użytkownik "Piwo" napisał w wiadomości
...
I have a macro that I want to run when a cells value changes due to a
selection from a list. How can I make this happen? Thanks in advance.


try to modify this one
i assumed that you cell is A2

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Target.Address = "$A$2" Then
Application.Run ...' your macro
End If
End Sub

mcg