So i've spent all day working on my user interface, thanks to alot of help from you guys, and just a few minutes ago i got the "sub too long" error... i'm not sure if there is an easier way to do what i'm trying to do with my userform, but here's the situation...

teacher selects name from combobox1, which then populates a list of classes in combobox 2. the selection of combo box 2 highlights the frames on the userform corresponding to the students in the class... there are 12 frames in total...

hoping to make my userform as user-error-free as i can, i coded it such that there is code for each frame (and the corresponding 9 option buttons and labels within) to either stay default color, or turn completely red...

so there is alot of code going on... it does exactly as i intend it to, but now i'm getting a compile error only about 70% of the way through all the classes...

any thoughts ? i could post some code or pix of the userform if it helps.

thanks so much everyone !

-rob