pop up message in excell
Posted on 2011-04-22
i have an excell sheet with two main fileds: student class: (1st secondary,2nd secondary, 3rd secondary, other,) now every class has its own score of success.
students in 1st secondary must get more than 60 out of 100 to sucseed, .....
now the user who is inputing the values will choose first the class then he will put the score, what i want is to evaluate the score the user is inputing & put a pop up message in case the student failed . in cas of faliour the a pop up message will appear & in this case the user cant continue inputing the other fileds unless he changes the score of the student to a succesfull score.
so each classs has its own failour scores.