I have few textboxes on a userform.
When I input 5000, which should get formated to 5,000, instead I get 4,970.
Can anywhen tell me why and how do I stop it?
this is the code I used
Private Sub CP_R1_Change() CP_R1.Text = Format(CP_R1.Text, "###,###,###") End Sub
Bookmarks