View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Hansen Rick Hansen is offline
external usenet poster
 
Posts: 104
Default 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