| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Writing output to a textbox while VBA macro is running | Excel Programming | |||
| writing data to a textbox in a chart | Excel Discussion (Misc queries) | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| VBA Userform Textbox re-writing cells in Excel | Excel Programming | |||
| Userform Textbox writing to a cell | Excel Programming | |||
![Greg B[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
