How to remove $ from listbox? I have text like this in my listbox. I want to remove all
AAAAA$,
BBB$
CCC$
ddd$

I want to remove this symbol $ from text to be display like this

AAAAA,
BBB
CCC
ddd


Code:
For i = 0 To List1.ListCount - 1 'select sheet
        If List1.Selected(i) = True Then
        Dim sheet As String
            sheet = (List1.List(i))
        End If
    Next