Capitals in textboxes

MJA · Apr 19th, 2002, 03:43 AM

Hello,

I wonder if the following can be done in VBA.

I have a userform with several textboxes, say three.
When I tab from textbox to textbox I want the text, in the textbox which I have left, to transform into capitals.

Or when I type the text in the textbox that it immediately transforms into capitals.

Is that in any way possible or do I want to much?!?!

nisht · Apr 19th, 2002, 03:54 AM

in text1 lost focus event write down following line..

text1 = strconv(text1,vbupper)

you can make here proper case... lower case..

and other options available in strconv..function.

nishith desai
http://www.pexcel.com

Apr 19th, 2002, 03:43 AM	#1
MJA Board Regular Join Date: Feb 2002 Location: Hengelo Posts: 79	Hello, I wonder if the following can be done in VBA. I have a userform with several textboxes, say three. When I tab from textbox to textbox I want the text, in the textbox which I have left, to transform into capitals. Or when I type the text in the textbox that it immediately transforms into capitals. Is that in any way possible or do I want to much?!?! __________________ Best regards, Martin J.A. Maatman Oonk

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

Apr 19th, 2002, 03:54 AM	#2
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	in text1 lost focus event write down following line.. text1 = strconv(text1,vbupper) you can make here proper case... lower case.. and other options available in strconv..function. nishith desai http://www.pexcel.com