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?
Bookmarks