Function Basic Extensions Class

TimesEqualFn

"Times Equals" or "Assign And Return Multiplication" Multiply 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 TimesEqualFn( _
      ByRef rLeft As Variant _
    , ByVal vRight As Variant _
    ) As Variant

Code Examples

    Assuming
       Dim dblValue As Double
       dblValue = 2.5
    for example
       TimesEqualFn(dblValue, 2) = 5
    leaves
       dblValue = 5
    rLeft = rLeft * vRight
    TimesEqualFn = rLeft
    #define TimesEqualFn(rLeft, vRight) (rLeft *= vRight)

Parameters

Parameter Description
rLeft Numeric or date value which is multiplied by vRight. The result of the multiplication 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 multiplied.