Private Sub Worksheet_Change(ByVal Target As Range)
Target.Value = UCase(Left(Target.Value, 1)) & Right(Target.Value, Len(Target.Value) - 1)
End Sub
[LEFT]Private Sub Worksheet_Change(ByVal Target As Range)[/LEFT]
Target = Application.Proper(Target)
end sub