No need to test - just convert

Range("a1") = StrConv(Range("a1"), vbUpperCase)

For the checking the data look at Data Validation as means of limiting the
input to 5 values.

Data--Validation--Allow: List -- Source:

Source can be a range in a worksheet or entered as values e.g. A,B,C,D,E
will only allow entries of A to E.

HTH

"Beth" wrote:

How can you test a cell to determine whether the letter entered (since it
will only be a letter) is capital, and if it isn't then have it
automatically capitalized?
Next how can you test to see if the value entered is in a range of 5 options?
Thanks for your anticipated help.