Sub Basic Extensions Class

DivideEqual

"Divide Equals" or "Assign Division" Divide rLeft by vRight and assign the result back into rLeft. Similar to the C language "/=" operator.

Signature (Visual Basic / VBA)

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

Code Examples

    Assuming
       Dim dblValue As Double
       dblValue = 2.5
    for example
       DivideEqual dblValue, 2
    leaves
       dblValue = 1.25
    Assuming
       Dim dblValue As Double
       dblValue = 2.5
    for example
       DivideEqual (dblValue), 2
    leaves
       dblValue = 2.5
    rLeft = rLeft / vRight
    rLeft /= vRight;

Parameters

Parameter Description
rLeft Numeric or date value which is divided by vRight. The result of the division is assigned back into the variable passed via rLeft, unless that value happens to be passed-by-value as in example #2.
vRight The numeric value by which rLeft is divided.

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.
Example #2 (bad example; has no effect; see below)
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.