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?