Format Cells to Capital Letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you format a cell so that regardless of how you type the letters into the cell it will format it to capitals?
 
John

Cannot do this via formatting.

You can enforce CAPS by using Data Validation, but this would just make the
user have to re-key.

Either make sure Caps Lock is on or use event code in the worksheet.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Target.Cells = Range("A1") Then Exit Sub
'for a column use this next line
' If Target.Column <> 1 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Right-click on sheet tab and "View Code".

Copy/paste the above code into the sheet module.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

text formating formulas 2
conditional formatting - highlight Capital letters but not lower c 2
HOW TO COUNT CAPITAL LETTERS IN DATA? 1
how to change small letters to capital letters 4
Change first letter of every word to Capital 7
Find the first letter in a cell 5
Capitalization of cells 2
Format cell to capital letters. 2

Back
Top