Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address = "$A$1" Then Target.Value = UCase(Target.Value)
If Target.Address = "$A$2" Then Target.Value = Application.Proper(Target.Value)
Application.EnableEvents = True
End Sub