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.

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.

converting lowercase to uppercase in userform
 

Excellent!! So Simple. I love it.
Thanks big time, Kevin.
J.O.