Function Formats Justifies Class

FormatRightJustifyTruncateFast

Apply the Visual Basic Format function then right justify the result. Undersized strings are left-padded with spaces to length vWidth. Oversized strings left-truncated to length vWidth. "Fast" function has restrictive argument types to avoid argument fix-up code.

Signature (Visual Basic / VBA)

Public Function FormatRightJustifyTruncateFast( _
      ByRef vValue As Variant _
    , ByRef vFormat As String _
    , ByVal vWidth As Long _
    ) As String

Code Example

    FormatRightJustifyTruncateFast(12345, "#,##0", 10) = "    12,345"
    FormatRightJustifyTruncateFast(12345, "#,##0",  5) = "2,345"

Parameters

Parameter Description
vValue Value which is to formatted. The formatted result is right-justified.
vFormat Format specification recognized by the Visual Basic Format function.
vWidth Length to which the formatted result will be space-filled or truncated.