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?
|