Title Capitalization

  • Thread starter Thread starter John Persico
  • Start date Start date
Either with a helper column and the PROPER function or VBA event code to
change in-cell when entered.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column <> 1 Then Exit Sub 'adjust to suit
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = Application.Proper(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP
 
The column that needs to be in Title Case is Column B.

Where do I enter the code?
I've never done anything with VBA.
Thanks for any help you can provide.
 
I've been away.

If you're still waiting.................

Right-click on the sheet tab and "View Code".

Copy/paste the code into that sheet module.

Adjust If Target.Column <> 1 Then Exit Sub to <> 2

Alt + q to return to Excel.


Gord
 
Back
Top