| Home |
| Search |
| Today's Posts |
|
#3
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. |
| 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 | |||
Threaded Mode
