Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Thanks alot Bob
Works Great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |