converting lowercase to uppercase in userform

[excelnut1954]

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.

[Kevin B]

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.
>
>

[excelnut1954]

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