VBA - Ltrim


Advertisements

The Ltrim function removes the blank spaces from the left side of the string.

Syntax

LTrim(String)

Example

Add a button and add the following function.

Private Sub Constant_demo_Click()
   Dim var as Variant
   var =       "             Microsoft VBScript"
   msgbox "After Ltrim : " & LTrim(var)
End Sub

When you execute the function, it produces the following output.

After Ltrim : Microsoft VBScript
vba_strings.htm
Advertisements