Caps in text boxes

[DaK]

Is there a way to make all entries in a text box be capitalized? For ex. if a person typed "ea7747" it would show up as "EA7747" without the user have to type in the ea in caps.

Thanks,
DaK

 

[Mark O'Brien]

Textbox in a Userform?

Sure is mate. My textbox is called "Textbox2", in my opinion it's the best Textbox that we've got between Testbox1 and Textbox3.

Put this code in the Textbox change event, changing all of the names to the name of your textbox, (not 'alf):

<pre>
Private Sub TextBox2_Change()
TextBox2.Text = UCase(TextBox2.Text)
End Sub</pre>

Hope this helps, mate.