Are you using worksheet_change Event? there is only 1 parameter. Check the
Target input parameter and only do your checking when the routine is called
from the proper cell

You can do something like this

if (Target.Row = 3) and (Target.Column 5) then

'perform needed checks
' can check any cells on the worksheet even if they arre not part of
target
if Worksheets("Sheet1").Range("A7") = 0 then
a = 5
else
if Worksheets("Sheet1").Range("A9") = 0 then
a = 6
end if
end if
end if



"Curt" wrote:

Is there a way to have multiple cell values checked befor triggering event.
Need to qualify 3 or 4 cells if possible. So far no luck. Whenever I try a
second qualifer it wont trigger.
This could be a befor close also I guess have never tried that. Think it
would do the same.
Any direction will be appreciated
Thanks