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 vote164 views1 answer
Open application from vbnet
VBA
-1 vote184 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
1 vote204 views1 answer
Vb.net get name by Cell Click
VBA
1 vote177 views1 answer
Random number generator vb.net
VBA
1 vote169 views1 answer
Add control vb
VBA
0 vote174 views1 answer
Vbs
VBA
9 votes336 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote189 views1 answer
Vba count all row
VBA
0 vote133 views1 answer
Vbide vbproject reference
VBA
0 vote173 views1 answer
Excel vba disable mouse click
VBA