macro for enable capslock

K

kalpesh

Hello

any macro for capslock is enable & enter any data in sheet 1 is write i
UPPPERCASE only
 
D

Don Guillett

Hello,

 any macro for capslock is enable & enter any data in sheet 1 is write in
 UPPPERCASE only
Click to expand...
right click the sheet tab>view code>insert this>

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Value = UCase(Target)
Application.EnableEvents = True
End Sub
 
C

Charlotte E.

any macro for capslock is enable& enter any data in sheet 1 is write in
UPPPERCASE only
Click to expand...

Put this in the sheet module:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Value = UCase(Target)
Application.EnableEvents = True
End Sub

CE
 
Top