Change
to![]()
ws.Cells(iRow, 1).Value = txt_PC.Value
![]()
ws.Cells(iRow, 1).Value = Left$(Replace$(Me.txt_PC.Value, " ", ""), 3) & _ " " & Mid$(Replace$(Me.txt_PC.Value, " ", ""), 4)
Change
to![]()
ws.Cells(iRow, 1).Value = txt_PC.Value
![]()
ws.Cells(iRow, 1).Value = Left$(Replace$(Me.txt_PC.Value, " ", ""), 3) & _ " " & Mid$(Replace$(Me.txt_PC.Value, " ", ""), 4)
Thank you so much Jindon for all your help and patience! I've learned so much! Hope others will see this as valuable as I did!!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks