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 vote286 views1 answer
Wpf dark title bar
VBA
5 votes272 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote239 views1 answer
Openfiledialog specific folder
VBA
3 votes230 views1 answer
Vba folderexists
VBA
0 vote217 views1 answer
Vba dropdown event
VBA
0 vote211 views1 answer
Create new worksheet excel visual basic
VBA
0 vote219 views1 answer
Vba loop through textboxes
VBA
3 votes212 views1 answer
Excel vba last row in range
VBA
3 votes249 views1 answer
Extract word in a text in excel
VBA
4 votes235 views1 answer
Excel vba how to get a range's full address including sheet name
VBA