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.