Need Code for real-time All Caps in Excel

[pbundrant]

I am working on an Excel form. Certain cells in the form must be typed (real-time) in Caps and other cells do not need special formatting.

I would like to use code to achieve this. I have read a few posts with code that is supposed to change text to caps, but I cannot get any of them to work.

If you can help me by posting an example or two of how I would go about doing this, I would greatly appreciate it. I am a VB beginner.

Thank you,

pmb