You can do this with DataValidation maybe
Select A1
Data Validation:(choose custom)
=EXACT(A1,UPPER(A1))
You must type in Uppercase now
--
Regards Ron de Bruin
http://www.rondebruin.nl
"K Dales" wrote in message ...
You could use a font that only has uppercase characters; but other than that
there is no built-in way to do it so you would need to use an event procedure
for the worksheet_change event.
--
- K Dales
"Ctech" wrote:
Hi
Is there a way to automatically set the Font to capitals, or UPPER, for
all text inserted in certain cells...
Or do I have to use an on event, macro that changes the text to UPPER
after text is inserted?
Thanks
--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=528142