String $ Functions
Use $ versions of string functions
VBA provides two versions of some of the commonly used string functions such as TRIM and TRIM$, MID and MID$, LCASE and LCASE$, etc. The $ version of the function returns a string value and is the one that should be used. The alternate version without the $ returns a variant value. Using the $ versions of these functions in your code will improve the performance of your applications.
One Response to “String $ Functions”
- Envision Newsletter December 2010 - Envision CAD | MicroStation Training & InRoads Training Says:
[…] VBA: String $ Functions […]