Caps Lock

[d_linthwaite]

Hi,

I want to make the below range of cells caps lock, so when i type in them, it automatically makes the text UPPERCASE!

Cell range G3:G55

Thanks

Dean

 

[VoG]

Right click the sheet tab, View Code, paste in the following

Private Sub Worksheet_Change(ByVal target As Range)
If target.Count > 1 Then Exit Sub
If Intersect(target, Range("G3:G55")) Is Nothing Then Exit Sub
target.Value = UCase(target.Value)
End Sub

then close the code window.