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?