View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_924_] Rick Rothstein \(MVP - VB\)[_924_] is offline
external usenet poster
 
Posts: 1
Default Excel: how to convert text to upper case upon entry?

The OP said "When I enter text data into an Excel cell", so I assumed that
if he is *entering* text, there would not be a formula to worry about.

Rick


"Mike H" wrote in message
...
To avoid changing formula into values I would suggest you ammend the line
in
Rick's code to this

If Not Target.HasFormula Then Target.Value = UCase(Target.Value)

Mike

"Doug Waters 03/03/08" wrote:

When I enter text data into an Excel cell, how can I get it to
automatically
be converted to upper case when I hit the Enter or Tab key? Yes, I know
about
the UPPER function - the problem is I want the data to be converted to
upper
case in the SAME CELL I just entered it into as lower case text.

Thanks for any help that anyone can provide.