The Trim$ function removes any leading or trailing space characters from a string.

' returns "abc"

strValue = Trim$ ("     abc     ")

Use the Trim$ function on all user entered text input. It is very easy for the user to enter a hidden space at the beginning or ending of a text field on a user form. Trimming all text inputs can eliminate a lot of frustrations in tracking down why your macro isn’t working properly.

Last Month’s Tips: