Function Basic Extensions Class

DivideEqualFn

"Divide Equals" or "Assign And Return Division" Divide rLeft by vRight, assign the result back into rLeft, and also return that value. Similar to the C language "/=" assignment operator in the case where that assignment is treated as an expression.

Signature (Visual Basic / VBA)

Public Function DivideEqualFn( _
      ByRef rLeft As Variant _
    , ByVal vRight As Variant _
    ) As Variant

Code Examples

    Assuming
       Dim dblValue As Double
       dblValue = 2.5
    for example
       DivideEqualFn(dblValue, 2) = 1.25
    leaves
       dblValue = 1.25
    DivideEqualFn = rLeft / vRight
    rLeft = rLeft / vRight
    #define DivideEqualFn(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) and the result is also returned.
vRight The numeric value by which rLeft is divided.