Can't reduce code as my procedure is too large.

Hi All,

I have a message on my UserForm that informs me my procedure is too large. The code below represents one of 60 variations and as you can see it
can be quite large. As you can deduce from the code, there is a left and a right which mirrors each other. The reason for this simplicity is so
I can easily edit and not lose my freedom when variations all called for. However, this is not possible and 99.9 per cent of the time the Left
mirrors right.

My question is this. Would having a line such as:

Please Login or Register  to view this content.

reduce the code Or is there an easier method I can use and not get too complicated for maintenance.

Please Login or Register  to view this content.

Hi,

It would reduce the code but it wouldn't work.

I imagine you should be refactoring the code so that any common parts go into separate routines that can be called from anywhere, and probably using some sort of lookup table logic. I think I've mentioned this to you before for precisely this reason and you said you were too far down the road to change, but now you know why I said it.

In an ideal world, all the actual business logic would be in its own classes and the form would merely call its methods to pass/retrieve any relevant data. FWIW.

All the control references refer to the userform holding the code unless otherwise specified.