Sub Basic Extensions Class

TimesEqual

"Times Equals" or "Assign Multiplication" Multiply rLeft by vRight and assign the result back into rLeft. Similar to the C language "*=" operator.

Signature (Visual Basic / VBA)

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

Code Examples

    Assuming
       Dim dblValue As Double
       dblValue = 2.5
    for example
       TimesEqual dblValue, 2
    leaves
       dblValue = 5
    rLeft = 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 (in which case, calling this function has no effect).
vRight The numeric value by which rLeft is multiplied.

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.