Text box question
 

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

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

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


--

HTH

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


"Greg B..." wrote in message
...
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

Thanks alot Bob

Works Great