Capital Letters

My application requires the user to enter the data in a cell only in capital letters. He normally puts the keyboard in "CAPSLOCK" on mode. But in case he forgets and notices that letters are not in capital he has to put the CAPSLOCK on and re-enter the data. How do I code in VBA to put the keyboard in CAPSLOCK on mode? In that case the user won't have to bother to switch on capslock.

Thanks

A V Veerkar

Thanks a lot DominicB. It works beautifully. I didn'tunderstand a word of what you put in Class1 module - I simply copy-pasted it and it works like a charm. I should have responded much earlier but I was away for a few days and didn't access the forum.

I would like to understand the code you put in Class1. Where can I get the dope? I will be good to know that part as well. I am reasonably comfortable at VBA for excel

Thanks a million again. It was wonderful.

A V Veerkar