• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro for eable capslock

Generally, it's better to design your programs to handle whatever the user inputs, rather than limit them. In the workbook, you can use the UPPER function, and in VB you can use the UCase method.


Is there some valid reason why only upper case data should be entered?
 
Back
Top