Upper case

[butterbean]

Is it possible to format, say, a column to automatically convert tex
entered in that column to upper case, no matter how the text i
entered?

That is, when the enter/tab is hit, the text will appear in upper case
no matter what the case when entered.

I am just trying to overcome having to remember to use the caps lock

 

[Don Guillett]

right click sheet tab>view code>insert this
Use a worksheet_change event such as

Private Sub Worksheet_Change(ByVal Target As Range)
if target.Cells.Count > 1 Or Target.HasFormula Then Exit Sub

On Error Resume Next
If Not Intersect(Target, Range("a1:g100")) Is Nothing Then
Application.EnableEvents = False
Target = UCase(Target)
Application.EnableEvents = True
End If
On Error GoTo 0

End Sub

 

[Jim Cone]

The free Excel add-in 'Excel Extras' will change selected cell text to
Upper, Lower, Proper or Sentence case by clicking the appropriate
menu item on the format menu.
It does other stuff too.
Download from... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


in message
Is it possible to format, say, a column to automatically convert text
entered in that column to upper case, no matter how the text is
entered?
That is, when the enter/tab is hit, the text will appear in upper case,
no matter what the case when entered.
I am just trying to overcome having to remember to use the caps lock.

 

[David McRitchie]

You could just as well use a range of A:G instead of
A1:G100 and be a lot less likely to need to update.
Actually the only thing I completely capitalize is zip state
codes and that is only one column so that might be E:E

related material in my
http://www.mvps.org/dmcritchie/excel/proper.htm

 

[paul]

in another column you could have =upper(a1) so everything you type in A1
appears in the other cell as upper case

 

[butterbean]

Thanks so much. That was my first question on this forum. Wonderful
response. Very impressed. Thanks again.
Peter

 

[butterbean]

David. Thanks also. Will investigate. I agree, is not a regula
requirement. This time, it is a table where 3 letters need to b
capitalised for presentation purposes. The macro should do it.

It suprises me that Office does not have something like this in it'
formatting dialogue, similar to the number and date formatting.
Pete