Uppercase Input

[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?

 

[Frank Kabel]

Hi
you need an event procedure. See:
http://www.cpearson.com/excel/case.htm

 

[Peo Sjoblom]

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

 

[Darlene Kupke]

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?

The easiest way is to format the cells in question to capitals format. Then
anything you enter is automatically capitalized.


bye

Darlene

 

[Gord Dibben]

Darlene

Info only.

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

Gord Dibben Excel MVP