Upper case
 

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.


--
butterbean
------------------------------------------------------------------------
butterbean's Profile: http://www.excelforum.com/member.php...o&userid=35730
View this thread: http://www.excelforum.com/showthread...hreadid=555164

Upper case
 

right click sheet tabview codeinsert 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


--
Don Guillett
SalesAid Software

"butterbean" wrote
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.


--
butterbean
------------------------------------------------------------------------
butterbean's Profile:
http://www.excelforum.com/member.php...o&userid=35730
View this thread: http://www.excelforum.com/showthread...hreadid=555164

Upper case
 

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


"butterbean" wrote 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.
--
butterbean

Upper case
 

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

Upper case
 

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

remove nospam for email addy!



"Jim Cone" wrote:

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


"butterbean" wrote 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.
--
butterbean

Upper case
 

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


--
butterbean
------------------------------------------------------------------------
butterbean's Profile: http://www.excelforum.com/member.php...o&userid=35730
View this thread: http://www.excelforum.com/showthread...hreadid=555164

Upper case
 

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

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


--
butterbean
------------------------------------------------------------------------
butterbean's Profile: http://www.excelforum.com/member.php...o&userid=35730
View this thread: http://www.excelforum.com/showthread...hreadid=555164