Cell tests for upper case, and certain #'s
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.
|