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
 

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

CAPITALIZED ALL WORDS FROM WROKSHEET 2
problem in ms excel 1
Restrictions in format 1
Capitalise first word in a cell 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Sentence with first letter in Capital, rest all in small. 3
Find the first letter in a cell 5
Sentence Case 2

Top