Write a subroutine in a module to change case upon exit of a cell to upper case

Hi everyone. I'm stuck on how to get this to work. Column M in my worksheet is used for U.S. state codes. If someone entering data into a cell in column M in the worksheet enters ca for California, the text should be converted to uppercase as soon as the cell is exited (it should read CA upon exit).

The code below does not work. I have it in a module. I have some code written in a worksheet_change event that does work, but I want to learn how to get it to work if I place it in a module. I'm trying to learn VBA and I just can't seem to grasp this concept.

Please Login or Register  to view this content.

Is there a way to write code in a module where:
1) Anytime sheet 2 is active
2) And a cell in column "M" is changed to a state code that is not upper case, such as "ca"
3) When that cell in column "M" is exited, the state code is should be changed to upper case and should read "CA"

I don't want this to go in the Worksheet_Change event because I have other things in that event already.