| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing All Caps in input cells
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Data input in cells | Excel Discussion (Misc queries) | |||
| Locking The Cells with Input At The Time of Saving The File | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| How do I match two cells and input a value in a different cell? | Excel Worksheet Functions | |||
Threaded Mode
