| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting lowercase to uppercase in userform
I want the results of Textbox1 in a userform to show uppercase even if
the user types in lower. Here's the line that populates Textbox1 TextBox1.Value = FindPOVal I looked in Help, but the example in there didn't work for me. I'm sure I wasn't using the example correctly.... Thanks, J.O. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
converting lowercase to uppercase in userform
Try TextBox1.Value = UCase(FindPOVal)
-- Kevin Backmann "excelnut1954" wrote: I want the results of Textbox1 in a userform to show uppercase even if the user types in lower. Here's the line that populates Textbox1 TextBox1.Value = FindPOVal I looked in Help, but the example in there didn't work for me. I'm sure I wasn't using the example correctly.... Thanks, J.O. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
converting lowercase to uppercase in userform
Excellent!! So Simple. I love it.
Thanks big time, Kevin. J.O. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| uppercase to lowercase | Excel Discussion (Misc queries) | |||
| Lowercase to uppercase | Excel Discussion (Misc queries) | |||
| uppercase to lowercase | Excel Worksheet Functions | |||
| lowercase to uppercase | Excel Worksheet Functions | |||
| uppercase to lowercase | Excel Discussion (Misc queries) | |||
Hybrid Mode
