Automatically Changing to Upper Case

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

Somewhere on one of my spreadsheets everytime I typed in text it would
change it to upper case. I have no idea how I did this. I did a
Google search, but I coudln't find anything that works without using
macros.

Is there a way to type in text to a cell and have it change
automatically to upper case without using macros?

Thanks
 
Jim,
Is there a way to type in text to a cell and have it change
automatically to upper case without using macros?
Click to expand...

No.

You probably are using the worksheet's change event code to achieve that.

HTH,
Bernie
MS Excel MVP
 
What is the change code event? Are you saying I had some code in
there I didn't know about?

Thanks
 
If you want to type text into a cell and have it automatically change to
upper case without using macros, touch the CAPSLOCK key first.

The CAPSLOCK key is usually located to the left of the "A" key
 
Right-click on the sheet tab and "View Code"

Paste this into that module.

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

Will UPPER case everything entered in columns A to H


Gord Dibben MS Excel MVP
 
I think the OP wanted an explanation why his data was
in upper case

--


Regards,


Peo Sjoblom
 
That's true, and I was also trying to find a way to do this with out
using a macro.

Thanks for the help.
 
Without a macro use the UPPER function, but that will not be automatic and
requires a helper cell for the formula.


Gord
 
Back
Top