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
|