Capitals in textboxes

[MJA]

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]

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.

ni****h desai
http://www.pexcel.com