upper case entries

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

cannot figure out how to make text I enter in a cell auotmatically convert
to upper case.
Upper formula only transfers it to another cell
what am I missing?
thanks
 
Dave

Use CAPS key?

Event code in the worksheet? This code will force all text to UPPER after you
type text in a cell and hit <ENTER>.

Right-click on sheet tab and "View Code". Copy/paste the code in there.

Operates on Columns A through H.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 8 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

Gord Dibben Excel MVP
 
Dave

you need to employ a Worksheet_Change event to monitor the cells and convert
them to upper case.

The following example checks for input in column A

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
Target.Value = UCase(Target.Value)
End Sub

Regards

Trevor
 
thanks both.... I know,Caps keys,,,duh. I was being lazy!
thought it might end up being a macro
I will give'em a try
thanks
 
Back
Top