If statement not catching on conditions

[cmdolcet69]

I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that can
anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
Exit Sub
End If

[Lloyd Sheen]

"cmdolcet69 " <co************ @hotmail.comwro te in message
news:0f******** *************** ***********@m32 g2000hsf.google groups.com...

>I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that can
anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
Exit Sub
End If

Any = Or
All = And

your statement wants all the conditions to be met before the exit will
occur.

LS

[=?Utf-8?B?QmV0aA==?=]

Did you want an OR connector instead of AND?
You said: should catch if ANY of the conditions are met

Would
If (not boolDSIFlushGap Reading) OR (muxClass.DSIVa lues.Count < 2) OR
(muxClass.COM1A ctive <1) Then

do it?

"cmdolcet69 " wrote:

I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that can
anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
Exit Sub
End If

[Jack Jackson]

On Wed, 29 Oct 2008 10:20:57 -0700 (PDT), cmdolcet69
<co************ @hotmail.comwro te:

>I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGa pReading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1A ctive =1 it will not exit the program??? Why is that can
anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
Exit Sub
End If

Your statement says to execut the Exit Sub only if all three
conditions are met. In your example the first one is not met and the
other two are.

Apparently you want Or instead of And. An Or test is true if either
item is true, and And test is true of both items are true.

Also, you should use AndAlso and OrElse instead of And and Or for
tests like this.

[cmdolcet69]

On Oct 29, 1:39*pm, Jack Jackson <jjack...@cinno vations.netwrot e:

On Wed, 29 Oct 2008 10:20:57 -0700 (PDT), cmdolcet69

<colin_dolce... @hotmail.comwro te:

I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that can
anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
* * * * * * * *Exit Sub
* * * * * *End If

Your statement says to execut the Exit Sub only if all three
conditions are met. *In your example the first one is not met and the
other two are.

Apparently you want Or instead of And. *An Or test is true if either
item is true, and And test is true of both items are true.

Also, you should use AndAlso and OrElse instead of And and Or for
tests like this.

Ok a step further lets say:
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =2 it will not exit the program???

How can I fix that.......

[cmdolcet69]

On Oct 29, 1:27*pm, "Lloyd Sheen" <sql...@hotmail .comwrote:

"cmdolcet69 " <colin_dolce... @hotmail.comwro te in message

news:0f******** *************** ***********@m32 g2000hsf.google groups.com...

I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that can
anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
* * * * * * * *Exit Sub
* * * * * *End If

Any = Or
All = And

your statement wants all the conditions to be met before the exit will
occur.

LS

No what happends is that DSIValues.Count can =1 but then the
muxclass.COM1Ac tive = 0
The only wat it doesn;t exist is that DSIValues.Count can =2 but then
the muxclass.COM1Ac tive = 1 or

DSIValues.Count can =1 but then the muxclass.COM2Ac tive = 2

[Armin Zingler]

"cmdolcet69 " <co************ @hotmail.comsch rieb

I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that
can anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2
And Not muxClass.COM1Ac tive = 1 Then
Exit Sub
End If

First I thought it could be a matter of operator precedence
(http://msdn.microsoft.com/en-us/library/fw84t893.aspx), but it's correct.

You expect the program to exit. Have you tested if the "Exit sub" statement
is reached (Debug.Print)? Or maybe it is reached but it doesn't cause the
expected behavior? Exit Sub exits the sub, not the program.
Armin

[cmdolcet69]

On Oct 29, 3:51*pm, "Armin Zingler" <az.nos...@free net.dewrote:

"cmdolcet69 " <colin_dolce... @hotmail.comsch rieb

I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGap Reading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1Ac tive =1 it will not exit the program??? Why is that
can anyone help me

Urgent!!!!!!

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2
And Not muxClass.COM1Ac tive = 1 Then
* * * * * * * *Exit Sub
* * * * * *End If

First I thought it could be a matter of operator precedence
(http://msdn.microsoft.com/en-us/library/fw84t893.aspx), but it's correct..

You expect the program to exit. Have you tested if the "Exit sub" statement
is reached (Debug.Print)? Or maybe it is reached but it doesn't cause the
expected behavior? Exit Sub exits the sub, not the program.

Armin

Armin it never exit the Sub and that all I want it to do is exit the
sub

[Armin Zingler]

"cmdolcet69 " <co************ @hotmail.comsch rieb

Armin it never exit the Sub and that all I want it to do is exit the
sub

It's possible that debugging has an influence on the result, in particular
as you are handling COM ports here (I guess) where the state can change
while debugging. For example, if you set a breakpoint and examine the
values, they can be different from those if you had not interrupted the
execution. Therefore, try this:

debug.write(boo lDSIFlushGapRea ding & " ")
debug.write(mux Class.DSIValues .Count & " ")
debug.writeline (muxClass.COM1A ctive)

If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 _
And Not muxClass.COM1Ac tive = 1 Then
debug.writeline ("exit sub")
Exit Sub
End If
I can not debug it here, so maybe exit sub is reached but the function is
called again and you think it is never left? I don't know. Is "exit sub"
ever shown in the debug/output window? Do you ever get the value combination
that you think should make the sub exit?

Armin

[Jack Jackson]

On Wed, 29 Oct 2008 11:38:16 -0700 (PDT), cmdolcet69
<co************ @hotmail.comwro te:

>On Oct 29, 1:39*pm, Jack Jackson <jjack...@cinno vations.netwrot e:

>On Wed, 29 Oct 2008 10:20:57 -0700 (PDT), cmdolcet69

<colin_dolce.. [e-mail] ote:

>I have the below if statement, that should catch if any of the
conditions are met.....however for some reasons if my
boolDSIFlushGa pReading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1A ctive =1 it will not exit the program??? Why is that can
anyone help me

>Urgent!!!!!!

>If boolDSIFlushGap Reading = False And muxClass.DSIVal ues.Count < 2 And
Not muxClass.COM1Ac tive = 1 Then
* * * * * * * *Exit Sub
* * * * * *End If

Your statement says to execut the Exit Sub only if all three
conditions are met. *In your example the first one is not met and the
other two are.

Apparently you want Or instead of And. *An Or test is true if either
item is true, and And test is true of both items are true.

Also, you should use AndAlso and OrElse instead of And and Or for
tests like this.

Ok a step further lets say:
boolDSIFlushGa pReading = true and MuxClass.DSIVal ues.count =1 and my
muxclass.COM1A ctive =2 it will not exit the program???

How can I fix that.......

I don't understand what behavior you want.

In the example above, it would not exit because only one of the
conditions is true, and when you use And all must be true.

If you use Or, then if any condition is true it will exit, so in your
example above if you changed the Ands to Ors (or preferrably OrElse)
it would exit since muxClass.DSIVal ues.Count is < 2.