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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Form Input Question 3
vbKeyCapital 5
CapsLock NumLock 2
Keyboard Shortcut changed after XP 0
Macro warning in word 1
Macro to select and delete levels of a document 2
how to se sendkeys 3
Quicker way to enable macros? 3

Top