Automatic caps changing

[jediknight]

Hi all,

Im trying to figure out how to automatically make a cell put any text input into caps whether this be paste or just simply typing, but i need to be able to do this without using the caps key so i dont have to keep switching it off and on for different cells.

I dont mind either a short key like in Word shift+F3 which i can do afterwards by selecting all the cells or a formula.

Many thanks.

[martindwilson]

look here
http://www.vbaexpress.com/kb/getarticle.php?kb_id=69
you can assign the macro to a short cut if you need

[Marcol]

Or in the worksheet change event

Please Login or Register  to view this content.

Change the Range to suit.

Assuming macros have been enabled by the user when the file is opened.

If macros have not been enabled then you could add a Sub to correct wrong entries later.
i.e.
Close the workbook, reopen with macros enabled, and run this sub

Please Login or Register  to view this content.

Hope this helps

[jediknight]

Great once again swift resolve to my issues.
many thanks for your help.