Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger a Macro
Can you trigger a macro by changing 1 cell?
Specifically if I change Cell Y1 of worksheet January I want SortModule.FRDSort to run. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger a Macro
right click the sheet tab you want it to run on and select view code
paste this and test it out Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count = 1 Then If Not Intersect(Target, Range("Y1")) Is Nothing Then MsgBox "run code" End If End If End Sub -- Gary "Patrick Simonds" wrote in message ... Can you trigger a macro by changing 1 cell? Specifically if I change Cell Y1 of worksheet January I want SortModule.FRDSort to run. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trigger macro on value only | Excel Programming | |||
macro trigger | Excel Discussion (Misc queries) | |||
Another way to trigger a macro? | Excel Programming | |||
Macro trigger? | Excel Programming | |||
Macro trigger? | Excel Programming |