ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textbox Writing (https://www.excelbanter.com/excel-programming/401975-textbox-writing.html)

Greg B[_11_]

Textbox Writing
 
Hi,

I am wondering what code would i use to have the first letter of a textbox
be changed to a capital letter?

i am using the text boxes firstname & surname as the textboxes

Thanks in advance

Greg B



Rick Rothstein \(MVP - VB\)

Textbox Writing
 
Only the first letter?

TextBox1.Text = UCase(Mid(TextBox1.Text, 1, 1)) & Mid(TextBox1, 2)

Rick


"Greg B" wrote in message
...
Hi,

I am wondering what code would i use to have the first letter of a textbox
be changed to a capital letter?

i am using the text boxes firstname & surname as the textboxes

Thanks in advance

Greg B




Greg B[_11_]

Textbox Writing
 
Thanks rick
Yes just for the names

Greg
"Rick Rothstein (MVP - VB)" wrote in
message ...
Only the first letter?

TextBox1.Text = UCase(Mid(TextBox1.Text, 1, 1)) & Mid(TextBox1, 2)

Rick


"Greg B" wrote in message
...
Hi,

I am wondering what code would i use to have the first letter of a
textbox be changed to a capital letter?

i am using the text boxes firstname & surname as the textboxes

Thanks in advance

Greg B







All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com