I would like to use the change event, but I don't know how write it.

I have this change event I have been using but don't know how to edit it to fit my needs.

Would you know how to change it?

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Or Target.HasFormula Then Exit Sub

    On Error Resume Next
    If Not Intersect(Target, Range("G11:G50")) Is Nothing Then
        Application.EnableEvents = False
        Target = UCase(Target)
        Application.EnableEvents = True
    End If
    On Error GoTo 0
    End Sub