Upper Case Column Setup

[JOB Dave]

Is there a way to set up a column to display upper case letters if lower case letters are inputted? I looked through various headers on this forum and found nothing. Then I brought up Excel and did some looking through Format Cells and did not fine anything.

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the code (in red) to match your desired column. Close the code window to return to your sheet. Enter a value in the column and press the ENTER key.

Please Login or Register  to view this content.

[JOB Dave]

I don't see what to click on to enter this code.

JOB Dave

[Mumps1]

Follow the instructions in my last post.