View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default TRUE and TRUE or TRUE then......

from the immediate window:

? false and true or true
True
? false and (true or true)
False

so why struggle. Use parens to make your intent clear.

why is it a problem - evaluating from left to right it would look like

(false and true) or true
(false and true) becomes false so the second evaluation is False or True

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy


"Susan" wrote:

duh... forget to say what the PROBLEM is.......
it keeps repeating thru this msgbox & won't
actually continue.

Susan wrote:
i have to believe i'm misreading this code, somehow. when
i watch chkboolean.value, it changes to false, as it should,
the first time the code is run through. but then when
it runs through a second time, this code should NOT
get triggered, because now chkboolean.value=false (which
it shows, correctly, in the watch window).

xxxxxxxxxxxxxxx

If chkBoolean.Value = True And _
optCouponsOnly.Value = True Or _
optSchedCoupons.Value = True Then
MultiPage1.pgCoupons.Visible = True
chkBoolean.Value = False
MultiPage1.Value = 1
txtProgID.SetFocus
MsgBox "Please also fill in these fields, then press ""Continue""."
_
, vbInformation, "Let's see................."
Exit Sub
chkBoolean.Value = False
End If

xxxxxxxxxxxxxxx

thanks for any assistance.
susan