| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper case 1st letter only
This is for when the value of a textbox is pasted.
I know that Application.Selection.Value = UCase(TextBox2.Text) will result in all caps. Is there a variation of the code that will result in just the1st letter being in caps? I searched but could not find any reference to this. Thanks jeff |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upper case 1st letter only
Hi
You can use the worksheetfunction 'Proper' like this: Application.Selection.Value = WorksheetFunction.Proper(TextBox2.Text) Regards, Per "jeff" skrev i meddelelsen ... This is for when the value of a textbox is pasted. I know that Application.Selection.Value = UCase(TextBox2.Text) will result in all caps. Is there a variation of the code that will result in just the1st letter being in caps? I searched but could not find any reference to this. Thanks jeff |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upper case 1st letter only
If you really mean only the first letter should be in caps and all the rest
of the letters in lower case... Selection.Value = UCase(Left(TextBox2.Text, 1) & LCase(Mid(TextBox2.Text,2) -- Rick (MVP - Excel) "jeff" wrote in message ... This is for when the value of a textbox is pasted. I know that Application.Selection.Value = UCase(TextBox2.Text) will result in all caps. Is there a variation of the code that will result in just the1st letter being in caps? I searched but could not find any reference to this. Thanks jeff |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upper case 1st letter only
On Sep 14, 2:28*pm, "Per Jessen" wrote:
Hi You can use the worksheetfunction 'Proper' like this: Application.Selection.Value = WorksheetFunction.Proper(TextBox2.Text) Regards, Per "jeff" skrev i ... This is for when the value of a textbox is pasted. I know that Application.Selection.Value = UCase(TextBox2.Text) will result in all caps. Is there a variation of the code that will result in just the1st letter being in caps? I searched *but could not find any reference to this. Thanks jeff- Hide quoted text - - Show quoted text - Thanks! Works just right. I played around with it myself, but I just couldn't get it the syntax right. I appreaciate the help. j.o. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upper case 1st letter only
You can use the VBA function StrConv(). Try
Msgbox StrConv("jeff & jacob skaria",vbProperCase ) If this post helps click Yes --------------- Jacob Skaria "jeff" wrote: On Sep 14, 2:28 pm, "Per Jessen" wrote: Hi You can use the worksheetfunction 'Proper' like this: Application.Selection.Value = WorksheetFunction.Proper(TextBox2.Text) Regards, Per "jeff" skrev i ... This is for when the value of a textbox is pasted. I know that Application.Selection.Value = UCase(TextBox2.Text) will result in all caps. Is there a variation of the code that will result in just the1st letter being in caps? I searched but could not find any reference to this. Thanks jeff- Hide quoted text - - Show quoted text - Thanks! Works just right. I played around with it myself, but I just couldn't get it the syntax right. I appreaciate the help. j.o. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upper Case Letters to First Letter Upper, Remaining Letters Lower | Excel Discussion (Misc queries) | |||
| 1st letter upper case | Excel Discussion (Misc queries) | |||
| lower case letter "i" always converts to upper case | Excel Discussion (Misc queries) | |||
| How do I change Letter case (lower to Upper) in a spreadsheet??? | Excel Discussion (Misc queries) | |||
| Excel Format Cell - first letter upper case | Excel Programming | |||
Linear Mode
