ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formatting Textbox (https://www.excelbanter.com/excel-programming/371495-formatting-textbox.html)

Rob

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

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


Roy Wagner

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


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