Caps Lock

d_linthwaite

New Member
Joined
Oct 5, 2006
Messages
8
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
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Right click the sheet tab, View Code, paste in the following

Code:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,850
Messages
5,544,650
Members
410,627
Latest member
georgealice
Top