both comboboxes are on the same userform.

we have to assign a grade for each student in the class, after each class, based on participation...

after several different incarnations, i've figured that the quickest way to do this is via 1 userform