Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If cell value changes in 2 cells
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If cell value changes in 2 cells
In your Worksheet Change event put something like this
if Not Intersect(Target,Me.Range("E5")) is Nothing then 'Do the events for E5 end if Repeat for H5 HTH, Barb Reinhardt "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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If cell value changes in 2 cells
in the code for the worksheet's change event ...
Private Sub Worksheet_Change(ByVal Target As Range) SELECT CASE Target.Address CASE "$E$5" ' do something CASE "$H$5" 'do something else CASE ELSE END SELECT End Sub "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
Unmerge cells and place contents of first cell in all cells | Excel Programming | |||
Copy cells into range of cells until cell change | Excel Worksheet Functions |