Workesheet Calculate - strange behaviour and theoretical question...
 

Hi all,

I have the following strange thing happening in a Worksheet Calculat
code:

there are three pieces of code, each one indipendent and triggered b
certain events on the sheet. they happen in the order that they are i
the code (=the second cannot be without the first, the third withou
the second). i have used the following structu

SUB WORKSHEET CALCULATE
IF...
END IF

IF..
END IF

IF...
END IF

END SU

Now, if they are all together in the code only the first gets triggere
but not the second and the third, even with the events triggering them
If each of them appears in the code as standlone (second but not 1s
and 3rd etc) they all work!

Am I missing something??

Many thanks

B

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=38565

Workesheet Calculate - strange behaviour and theoretical question...
 

Sounds like you need 1, than 2, than 3
You can put addiontional code between the if's.
you can add ElseIf's, Else....

If condition1 then

if condition2 then

if condition 3 then

end if

endif

End If

--
steveB

Remove "AYN" from email to respond
"bondcrash" wrote
in message ...

Hi all,

I have the following strange thing happening in a Worksheet Calculate
code:

there are three pieces of code, each one indipendent and triggered by
certain events on the sheet. they happen in the order that they are in
the code (=the second cannot be without the first, the third without
the second). i have used the following structu

SUB WORKSHEET CALCULATE
IF...
END IF

IF..
END IF

IF...
END IF

END SUB

Now, if they are all together in the code only the first gets triggered
but not the second and the third, even with the events triggering them.
If each of them appears in the code as standlone (second but not 1st
and 3rd etc) they all work!

Am I missing something??

Many thanks

BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=385657