Title Capitalization

G

Gord Dibben

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
 
J

John Persico

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a macro to create a separate document that lists all capitalized words 6
Disable Outlook AutoCorrect with GPO 0
Word isn't capitalizing the first word of each sentence 2
Replacing a phrase with carriage returns 1
Re-title multiple MS Project .mpp files at once 0
Space at end of multi page list to accommodate new entries 1
Capitalizing Words In The Middle Of Sentences 0
Visio Diagram Protection 0

Top