I am currently working on a file where a numbered grade is given to an assignment, to signify how far along they are. There are certain conditions that would have to be met to acheive a grade. For example, a 1 would mean that no conditions have been met, a 5 would mean that all conditions have been met.
I'm trying to figure out a way so that the comment box would display only the conditions that have to be met for that grade to be valid. So, if they put in a 1, the comment box would show "No conditions met" or if they put in a 5, the comment box would say "This has happened, this has happened, and this has happened." But it will only show the appropriate comment.
I imagine that it would be an "if/then" type of macro code, but I have no idea what code would be used to create a comment box, or change or delete it so that it shows the correct comment if they change the number. Also, I've never been able to get a "change event" macro to work with drop down boxes in excel, so that's another problem.
Any help is greatly appreciated.
Bookmarks