Text box question

[Greg B...]

Hi I am copying data from a textbox to a spreadsheet how do I convert all
characters in the textbox to CAPS please.


Thanks in advance

Greg

[Greg B...]

I forgot to add the code I am using so far

R = 17 'or whatever desired row variable
Sheets(2).Cells(R, 6).Value = TextBox1.Text
seasonname4.Hide


Thanks in advance

Greg

[Bob Phillips]

Sheets(2).Cells(R, 6).Value = UCase(TextBox1.Text)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B..." <[email protected]> wrote in message
news:[email protected]...
> I forgot to add the code I am using so far
>
> R = 17 'or whatever desired row variable
> Sheets(2).Cells(R, 6).Value = TextBox1.Text
> seasonname4.Hide
>
>
> Thanks in advance
>
> Greg
>
>

[Greg B...]

Thanks alot Bob

Works Great