still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 847
- Office Version
- 365
- Platform
- Windows
Hi
I use this event macro to change the text to proper case.
I had to use an ‘s for the first time. It changed the ‘s to proper case
Example:
type in dave’s macro will change it to Dave’S after I hit enter
How do I change the macro to keep the ‘s in lower case
mike
I use this event macro to change the text to proper case.
I had to use an ‘s for the first time. It changed the ‘s to proper case
Example:
type in dave’s macro will change it to Dave’S after I hit enter
How do I change the macro to keep the ‘s in lower case
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Application.EnableEvents = False
Target.Value = Application.Proper(Target.Value)
Application.EnableEvents = True
End If
End Sub
mike