Signature (Visual Basic / VBA)
Public Function FormatRightJustifyFast( _
ByRef vValue As Variant _
, ByRef vFormat As String _
, ByVal vWidth As Long _
) As String
Code Example
FormatRightJustifyFast(12345, "#,##0", 10) = " 12,345"
FormatRightJustifyFast(12345, "#,##0", 3) = "12,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 if its length is less than vWidth. |