Using OR for Value Assignments

[j3rmz]

Hi all,

Has anyone used OR for value assignments?

For eg.

Dim value as integer

value = 3 or 4

I can't seem to understand the logic behind this.

Thanks.

 

[oldbrewer]

what is your source for this, please ?

 

[ttray33y]

Hi all,

Has anyone used OR for value assignments?

For eg.

Dim value as integer

value = 3 or 4

I can't seem to understand the logic behind this.

Thanks.

value = 3
;then
For value = 3
if blah2x value = blah3x Or blah value + 1 = blah4x then blah5x
end if
Next value

 

[j3rmz]

what is your source for this, please ?

Hi oldbrewer, I suppose you are requesting for my source code. Here's a sample :

Sub Test()


    Dim outputval As Integer
    Dim inputval As Integer
    Dim modval As Integer
    
    modval = 4
    
    For inputval = 1 To 10
        outputval = inputval Or modval
        Debug.Print outputval
        
        outputval = -1
    Next inputval
    


End Sub

So I'm tyring to figure the logic behind this part : "outputval = inputval Or modval".

The For loop is for me trying to figure out a pattern, to which I have none for the moment. Haha

 

[j3rmz]

value = 3
;then
For value = 3
if blah2x value = blah3x Or blah value + 1 = blah4x then blah5x
end if
Next value

Sorry, I don't understand what you mean by this. Would you mind explaining more?

Thanks.

 

[oldbrewer]

thanks - I personally have no idea, but will monitor this post to learn...

 

[oldbrewer]

[h=2]Or Operator Example[/h]This example uses the Or operator to perform logical disjunction on two expressions.
<code>Dim A, B, C, D, MyCheck
A = 10: B = 8: C = 6: D = Null ' Initialize variables.
MyCheck = A > B Or B > C ' Returns True.
MyCheck = B > A Or B > C ' Returns True.
MyCheck = A > B Or B > D ' Returns True.
MyCheck = B > D Or B > A ' Returns Null.
MyCheck = A Or B ' Returns 10 (bitwise comparison).
</code>

 

[oldbrewer]

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]modval = 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] outputval = 2 Or modval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] Cells(1, 1) = outputval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"] End Sub[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]returns 6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]modval = 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] outputval = 3 Or modval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] Cells(1, 1) = outputval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"] End Sub[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]returns 7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]modval = 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] outputval = 4 Or modval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] Cells(1, 1) = outputval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"] End Sub[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]returns 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]modval = 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] outputval = 5 Or modval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] Cells(1, 1) = outputval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"] End Sub[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]returns 5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]modval = 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] outputval = 6 Or modval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"] Cells(1, 1) = outputval[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"] End Sub[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]returns 6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]