VBA Ok Click() If Statement Procedure Too Long

Hi,

I'm trying to create a workbook with a userform including tick boxes. And depending on what tick boxes are 'clicked' a new worksheet opens with information on the options clicked.

However, there are to be at least 40 tick boxes and there is lots of information. I got so far before hitting the 'Procedure too large' error. I cannot figure out (even from looking at other forums on various websites including this one) how to overcome this problem. All the information for the IF statements for the tick boxes are based in the Private_Sub OK_Click(). Some code is below, but this thread can only be 15000 characters long. Before asking the text that I am wanting to input into the cells is not finished yet which is why there are only 2-3 words. I haven't used VBA for long and any answers would be very helpful and much appreciated. I hThanks

Please Login or Register  to view this content.

Sorry about the length