Vba remove last vbcrlf

' Removes the Line Break from the string if my string Ends with Line Break
Sub RemoveLineBreak(myString)
    If Len(myString) > 0 Then
        If Right$(myString, 2) = vbCrLf Or Right$(myString, 2) = vbNewLine Then 
            myString = Left$(myString, Len(myString) - 2)
        End If
    End If
End Sub

Source: stackoverflow.com

Similar codes

0 vote355 views1 answer
Write listbox to text file vb.net
VBA
1 vote340 views1 answer
Excel vba first and last row and column in range
VBA
0 vote360 views1 answer
Vba loop through textboxes
VBA
0 vote389 views1 answer
Excel vba set cell value to empty
VBA
0 vote345 views1 answer
Compare dates vb
VBA
0 vote349 views1 answer
Search in richtextbox vb.net
VBA
0 vote360 views2 answers
Do until loop vba
VBA
0 vote356 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote338 views1 answer
Vba dictionary length
VBA
0 vote357 views1 answer
Excel vba round to whole number
VBA