Title Case Validation
Thanks, it worked perfectly
"Mike H" wrote:
maybe a bit to buggy, try this instead
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
Target.Formula = WorksheetFunction.Proper(Target.Formula)
End Sub
"Mike H" wrote:
Hi,
Right click your sheet tab, view code and past this in. Text entered will be
changed to proper
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Formula = WorksheetFunction.Proper(Target.Formula)
End Sub
Mike
"jen2018" wrote:
How can I make sure that people enter information into a cell in Title Case?
|