Thread: Running a macro when there is a given cell entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Running a macro when there is a given cell entry
Hi,

Pretty simple with an event macro ...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = "Y" Then
Application.Run ("yourmacro")
End If
End Sub

HTH
Carim

Reply With QuoteReply With Quote