uppar case

  • Thread starter Thread starter shekhar
  • Start date Start date
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
 
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...
 
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

how do i change the words from lower case to uppercase/capitals 3
How to type each letter of the alphabet automatically in a specific color in Word? 0
how to change small letters to capital letters 4
CAPITALIZED ALL WORDS FROM WROKSHEET 2
HOW TO COUNT CAPITAL LETTERS IN DATA? 1
EXCEL Capital Letters 1
TRUE: Would like it to appear as "True" in the cell. 2
Selectively printing 1

Back
Top