Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making text in Title Case automatically
hi, how can i make all the text inputs be in Title Case format automatically, even if the user input a different case pattern? -- tweety127 ------------------------------------------------------------------------ tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673 View this thread: http://www.excelforum.com/showthread...hreadid=550498 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making text in Title Case automatically
Would require worksheet event code.
As written, the code below affects all cells in columns A through H Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column 8 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = Application.Proper(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub Right-click on sheet tab and "View Code". Copy/paste the code into that module. Gord Dibben MS Excel MVP On Fri, 9 Jun 2006 17:50:52 -0500, tweety127 wrote: hi, how can i make all the text inputs be in Title Case format automatically, even if the user input a different case pattern? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making all text become lower case | Excel Discussion (Misc queries) | |||
Use "PROPER" to change UPPERCASE text to Title Case on worksheet | Excel Worksheet Functions | |||
automatically change text case on entry | Excel Discussion (Misc queries) | |||
Change case from UPPER to Title Case?? | Excel Discussion (Misc queries) | |||
How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions |