Caps in text boxes

DaK · Apr 29th, 2002, 02:28 PM

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 · Apr 29th, 2002, 02:44 PM

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):



Private Sub TextBox2_Change()

  TextBox2.Text = UCase(TextBox2.Text)

End Sub

Hope this helps, mate.

Apr 29th, 2002, 02:44 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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): Private Sub TextBox2_Change() TextBox2.Text = UCase(TextBox2.Text) End Sub Hope this helps, mate. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 02:28 PM	#1
DaK New Member Join Date: Apr 2002 Posts: 16	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