uppar case

S

shekhar

i want to know that if in excel sheet we type in small letter and we want to
make that all in capital letter how to do that

regards,
shekhar
 
D

Dave Peterson

You can use a formula in another cell:
=upper(a1)
i want to know that if in excel sheet we type in small letter and we want to
make that all in capital letter how to do that

regards,
shekhar
Click to expand...
 
G

Gord Dibben

As you type...............

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 2 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Any cell you type into in columns A and B will be turned to UPPER case when
you hit ENTER

This is sheet event code.

Right-click on the sheet tab and "View Code". Copy/paste the code into that
module.

Edit the range to suit.


Gord Dibben MS Excel MVP
 
Top