VBA Function: Abs

The VBA Abs function returns the absolute value of a number.

Usage:

Abs(number)

Example of Usage

Applying the Abs function to the result of subtraction to obtain a positive result:

Sub example()

    number1 = 124.54
    number2 = 189.36
    
    difference = Abs(number1 - number2)

    MsgBox difference 'Returns: 64.82
    
    difference = Abs(number2 - number1)

    MsgBox difference 'Also returns: 64.82
    
End Sub