Macro to convert lowercase to uppercase upon data entry - Excel 2010

[AnnetteB]

I am having difficulty finding a macro that will work in Excel 2010 to convert lowercase letters to uppercase letters upon data entry in Excel 2010. Thank you!

[HaHoBe]

Hi, AnnetteB,

for one small range only, for a complete worksheet, for a workbook?

This is a sample for a limited range in a worksheet, code goes behind the sheet (right-click on the worksheet tab, View Code, insert the code there):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:Z250")) Is Nothing Then
  Application.EnableEvents = False
  Target.Value = UCase(Target.Value)
  Application.EnableEvents = True
End If
End Sub

Ciao,
Holger