"sub too long" error ? what can i do ?

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

Hi

The limit for procedures in Excel is 64k lines of code and above that you will get a compile error.

Without seeing any code it is difficult to comment, but is it necessary to code each item individually, could you not loop through them and apply the formatting?

Regards

Jeff