Returning strings from functions
Some functions have two versions: one that returns a Variant data type and one that returns a String data type. The Variant versions are more convenient because variants handle conversions between different types of data automatically. They also allow Null to be propagated through an expression. The String versions are more efficient because they use less memory.
Consider using the String version when:
- Your program is very large and uses many variables.
- You write data directly to random-access files.
The following functions return values in a String variable when you append a dollar sign ($) to the function name. These functions have the same usage and syntax as their Variant equivalents without the dollar sign.
| Function | Function | Function |
|---|---|---|
| Chr$ | ChrB$ | *Command$ |
| CurDir$ | Date$ | Dir$ |
| Error$ | Format$ | Hex$ |
| Input$ | InputB$ | LCase$ |
| Left$ | LeftB$ | LTrim$ |
| Mid$ | MidB$ | Oct$ |
| Right$ | RightB$ | RTrim$ |
| Space$ | Str$ | String$ |
| Time$ | Trim$ | UCase$ |
* May not be available in all applications.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for