I have a data entry spreadsheet that will be used by multiple employees.
For ease of viewing later, I want to ensure that all data entered into
the input cells are in all caps.

Is there a way to force cells to display all caps at the time of input?


If not, is there a way in VBA that I can create a macro that will
change the case of the contents of these cell?


--
Slave2Six
------------------------------------------------------------------------
Slave2Six's Profile: http://www.excelforum.com/member.php...o&userid=36904
View this thread: http://www.excelforum.com/showthread...hreadid=566195