excel vba userform textbox
In the change event of the textbox.
If someone highlights the textbox contents and then copies and pastes things into the textbox..the textbox seems to just keep the old values in and gets jumbled with alot of spaces.
Private Sub TextBox37_Change()
'Dim t As String
't = UCase(UserForm2.TextBox37.Text)
'UserForm2.TextBox37.Text = t
UserForm2.TextBox37.Text = UCase(TextBox37.Text)
What I need: sone clean of of making sure extra spaces and wahtever was there before gets cleaned out before typing or copy and pasting new values into the textbox ?