Macro run from If Then function
HI Nikki,
Add the following code the to Worksheet_Change() event on the worksheet
where the cell is located.
hth, Rick
Private Sub Worksheet_Change(ByVal Target as Range)
If Target.address = "$C$4" and Target.Value = "Y" Then ' <<
Change cell address
Call MacroX
End If
End Sub
"Nikki" wrote in message
...
The goal is to run 'MacroX' if cell equals Y. Is that even possible
|