The Trim function removes both the leading and the trailing blank spaces of the given input string.
Syntax
Trim(String)
Example
Add a button and add the following function.
Private Sub Constant_demo_Click() var = "Microsoft VBScript" var = " Microsoft VBScript " msgbox ("After Trim : " & Trim(var)) End Sub
When you execute the above function, it produces the following output.
After trim : Microsoft VBScript
Previous Page:-Click Here
Pingback: VBA - Strings - Adglob Infosystem Pvt Ltd