Click Here For FREE VBA MS Access Training!

true 100% comissions


Great MS Excel VBA Books From Amazon:
Click Here To View My List Of MS Excel VBA Books!

VBA Trim

This is a text and video example of how to write a VBA Trim function:

*************************************************************************************
Public Sub GetLastName()

      Dim strLastName As String

      strLastName = Range("A2")

      strLastName = Right(strLastName, 8)

'THE TRIM FUNCTION CLEANS THE VBA STRING VARIABLE OF
'ANY LINGERING SPACES BOTH BEFORE AND AFTER...
'IT MAKES " Jack" (WITH A SPACE IN THE BEGINNING)
' LOOK LIKE "Jack" (NO SPACES).


      strLastName = Trim(strLastName)

      Range("C2") = strLastName

End Sub

*************************************************************************************

Now watch how it's done...


That's all, I hope it helped! If not, feel free to email me at erik [at] vbahowto [dot] com

Are you struggling to learn VBA?

If your answer to the above question is yes, then I strongly recommend that you check out these VBA Crash Course videos



Click Here For FREE VBA MS Access Training!

true 100% comissions


Great MS Excel VBA Books From Amazon:
Click Here To View My List Of MS Excel VBA Books!