Signature (Visual Basic / VBA)
Public Function TrimInPlace( _
ByRef rValue As Variant _
) As Variant
Code Example
Assuming
Dim S As String
S = " This is a sample. "
for example
TrimInPlace(S) = "This is a sample."
leaves
S = "This is a sample."
Parameters
| Parameter | Description |
|---|---|
| rValue | String argument which is to have all surrounding space characters removed. Function also returns the "trimmed" value of rValue. |
Notes & Version History
| Note | Function only works for characters in the ANSI Windows character set because it uses the built-in Visual Basic Trim() function. |