Private Sub Text1_Change() Dim i, s s = "" For i = 1 To Len(Text1) If Mid(Text1, i, 1) >= "0" And Mid(Text1, i, 1) <= "9" Then s = s + Mid(Text1, i, 1) End If Next i Text2 = sEnd Sub