Automatically Changing to Upper Case

[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

 

[Bernie Deitrick]

Jim,

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

No.

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

HTH,
Bernie
MS Excel MVP

 

[JimS]

What is the change code event? Are you saying I had some code in
there I didn't know about?

Thanks

 

[Gary''s Student]

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

 

[Gord Dibben]

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

 

[Peo Sjoblom]

I think the OP wanted an explanation why his data was
in upper case

--


Regards,


Peo Sjoblom

 

[JimS]

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

Thanks for the help.

 

[Gord Dibben]

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


Gord