| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
or strconv()
Frank Kabel wrote: Hi Json try using application.proper for this "Jason Morin" wrote: Hi Bob. I'm interested to know what the code would look like if you wanted to capitalize the first letter in each word in a cell using worksheet_change. richard m. smith = Richard M. Smith. I tried but failed. Jason -----Original Message----- Hi Craig, One way Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target .Value = UCase(Left(.Value, 1)) & _ LCase(Right(.Value, Len(.Value) - 1)) End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH ------- Bob Phillips "Craig Brody" wrote in message news:2FA928AA-5FBD-4EE5-BED9- ... Appreciate any help.... How do you get Excel to capitalize the first letter when typing a name in each cell. Example, when I type a name, I have to manually capitalize the first letter in the name. Thank you very much Craig Brody . -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to type a text in a cell, but I want that text to represen. | Excel Discussion (Misc queries) | |||
| Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
| Excel: type "ACN" into a cell and you get "CAN" why? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Function / formula to be used if cell contains a letter. | Excel Worksheet Functions | |||
Threaded Mode
