upper case

[JB]

Hello
Got grids for teachers to enter data and grades and unbelievably even when
asked to enter the grades in upper case, some still enter the grades in
lower case!!?
I know the formula to change data in cells from lower case into upper case,
but is there not an auto caps, or macro or validation that you can have
beforehand in the cell so that when the grade is entered it automatically
converts to upper case? like you can do in Access.
Thanks

 

[Sandy Mann]

Got grids for teachers to enter data and grades and unbelievably even when

asked to enter the grades in upper case, some still enter the grades in
lower case!!?

I believe it! <g>

Assuming that there are no formulas in the range, enter this Macro in the
sheet Module:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value = UCase(Target.Value)
Application.EnableEvents = True

End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk