Uppercase Input

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I want to format a cell so that any characters inputted into that cell are
automatically saved as uppercase in that cell. How do I do that?
 
One way, right click the sheet tabe and select view code and paste in the
following:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
If Target.Column > 6 Then Exit Sub
For Each cell In Target.Cells
With cell
If Not .HasFormula And Not IsNumeric(.Value) Then
Application.EnableEvents = False
.Value = UCase(.Value)
Application.EnableEvents = True
End If
End With
Next cell
End Sub

this will uppercase everything in the first 6 columns, change to fit
The press Alt + Q to close the VBE, save workbook

Regards,

Peo Sjoblom
 
I want to format a cell so that any characters inputted into that cell are
automatically saved as uppercase in that cell. How do I do that?
Click to expand...
The easiest way is to format the cells in question to capitals format. Then
anything you enter is automatically capitalized.


bye

Darlene
 
Darlene

Info only.

Excel does not have that "capitals" feature as Word has.

Gord Dibben Excel MVP
 
Back
Top