Remove comma from a textbox

[kelly mort]

Private Sub lstView_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Dim n As Integer, ac As Integer, i As Integer
        i = Me.lstView.ListIndex
    With lstView
        For ac = 1 To .ColumnCount
            .TextColumn = ac
            Me.Controls("Rw" & ac).Value = .Text
        Next ac
    End With
End Sub

I am using this code to load data to my textboxes. The number columns are formatted to accounting and the comma is affecting my calculations on the userform. Textboxes with those comma are not calculated.

so I am looking for a way to remove any comma when I load the textboxes with the above code. It can be, remove the comma before the data reaches the textbox or load it before removing it.

Whatever works is cool. But the earlier is cooler

Thanks

 

[Akuini]

Maybe this:

Me.Controls("Rw" & ac).Value = Replace(.Text, ",", "")

 

[kelly mort]

Maybe this:

Me.Controls("Rw" & ac).Value = Replace(.Text, ",", "")

Brilliant! !!

Thanks

 

[Akuini]

You're welcome & thanks for the feedback.