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.


Since 1996, EnvisionCAD has been a nationally recognized leader in the configuration, customization, implementation, training & support for CAD software solutions. Our individualized approach has benefited private engineering firms and government agencies alike. Basic or advanced, we can help you get the most from your CAD technology.


Leave a Reply

Your email address will not be published. Required fields are marked *