![]() |
Formatting Textbox
How do I make it so that the textbox in my userform is always all caps even
if the user inputs non-cap letters? I looked at all the properties that i can find and i just can't seem to figure it out but I'm sure it can be done, somehow... Thanks. Rob |
Formatting Textbox
Nevermind I found my own answer but Thanks anyhow.
"Rob" wrote: How do I make it so that the textbox in my userform is always all caps even if the user inputs non-cap letters? I looked at all the properties that i can find and i just can't seem to figure it out but I'm sure it can be done, somehow... Thanks. Rob |
Formatting Textbox
and you probably added something like this to the textbox change event:
Textbox1.Text = Ucase(Textbox1.Text) "Rob" wrote: Nevermind I found my own answer but Thanks anyhow. "Rob" wrote: How do I make it so that the textbox in my userform is always all caps even if the user inputs non-cap letters? I looked at all the properties that i can find and i just can't seem to figure it out but I'm sure it can be done, somehow... Thanks. Rob |
Formatting Textbox
Precisly.
"Roy Wagner" wrote: and you probably added something like this to the textbox change event: Textbox1.Text = Ucase(Textbox1.Text) "Rob" wrote: Nevermind I found my own answer but Thanks anyhow. "Rob" wrote: How do I make it so that the textbox in my userform is always all caps even if the user inputs non-cap letters? I looked at all the properties that i can find and i just can't seem to figure it out but I'm sure it can be done, somehow... Thanks. Rob |
All times are GMT +1. The time now is 01:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com