Hi,
Im trying to create a way to validate a cell value, or score, when the User
tabs off of the cell. The first possible cell that will receive a score will
be C13 and there can be an indeterminate number of columns and rows, however
I dont believe that scores will be entered beyond column AB nor past row 50.
The maximum possible score in each column is located in row 12 respectively
and I want to make sure that the score in each column does not exceed the
value in row 12. For example, column E (from row 13 downward) may contain
scores related to fractions aptitude with the maximum possible score of 10 in
cell E12. Currently, Im using Excels built in data validation feature, but
some people have figured out how to get around it. Is there an event
procedure, or other process, that will do the validation process?
Thanks,
Mark


-----------------------------------------------------------------------------
Less Spam Better enjoyable experience
Visit : news://spacesst.com