Format User Defined Text
Description
The following text formats may be used with the Format function. Text formats may be combined to create the user defined text format. User defined text formats may not be combined with other user defined formats or predefined formats.
User defined text formats can contain one or two sections separated by ';':
- form - format for all strings
- form;nullform - nullform: format for empty and null strings
| Parameter | Description |
|---|---|
| @ | char placeholder, insert char or space |
| & | char placeholder, insert char or nothing |
| < | all chars lowercase |
| > | all chars uppercase |
| ! | fill placeholder from left-to-right (default is right-to-left) |
| \c | insert character c |
| "text" | insert literal text |
Example
Sub Main
Debug.PrintFormat("123","ab@c")
'" ab1c23"
Debug.PrintFormat("123","!ab@c")
'" ab3c"
End Sub