String $ Functions

Published on December 7, 2010

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.

Like this article? Share it!

One Response to “String $ Functions”

  1. Envision Newsletter December 2010 - Envision CAD | MicroStation Training & InRoads Training Says:

    April 11th, 2011 at 4:56 pm

    […] VBA: String $ Functions […]

Leave a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Privacy Policy