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?