Changing text to upper case

I'm wanting to ensure that text entered by the user displays in upper case but I can't figure out how to do this. For example, if text is entered into cell A1, how can that text be changed to upper case?

I know that using the function UPPER() in some other cell will display the text in that cell in upper case but the text in A1 remains unchanged.

hi
try this

http://www.ozgrid.com/VBA/force-case-text.htm


steve

Excellent! Works great. Thanks, Steve.