Sub Basic Extensions Class

PlusEqual

"Plus Equals" or "Assign Addition" Add vRight to rLeft and assign the result back into rLeft. Similar to the C language "+=" operator.

Signature (Visual Basic / VBA)

Public Sub PlusEqual( _
      ByRef rLeft As Variant _
    , ByVal vRight As Variant _
    )

Code Examples

    Assuming
       Dim dblValue As Double
       dblValue = 2.5
    for example
       PlusEqual dblValue, 2
    leaves
       dblValue = 4.5
    rLeft = rLeft + vRight
    rLeft += vRight;

Parameters

Parameter Description
rLeft Numeric or date value to which vRight is added. The result of the addition is assigned back into the variable passed via rLeft, unless that value happens to be passed-by-value (in which case, calling this function has no effect).
vRight The numeric value that is added to rLeft.

Notes & Version History

Summary This function is usually faster than the macroized eqivalent ("rLeft = rLeft + vRight") if rLeft is not a simple variable. This is because rLeft is passed-by-reference so that Visual Basic must only evaluate its address once.
Note We would NOT use this subroutine to replace something like "dblValue = dblValue + 2", but we WOULD use it to replace something like "adblMatrix(intColumn, intRow, intItem) = adblMatrix(intColumn, intRow, intItem) + 2", especially since we only have to mention the "adblMatrix(intColumn, intRow, intItem)" part once.