View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default If cell value changes in 2 cells

Selec the Worksheet Change event

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Range("$E$5")) Is Nothing Then
'events
End If

If Not Application.Intersect(Target, Range("$H$5")) Is Nothing Then
'events
End If

End Sub

--
If this post helps click Yes
---------------
Jacob Skaria


"Kashyap" wrote:

Hi, I have a set of tasks to be done when value in E5 changes.. but I need to
do another set of tasks when value in H5 changes as well.. How to go around
it?