VBA Multiple Process Splits

I am working on a large project and I keep running into this issue.

COMPILE ERROR: Procedure too Large.

I have avoided this by writing around 1000 lines under
Private Sub Userform_Initialize()

then after another 1000
Private Sub Userform_Activate()

but I need more space under the same userform.

I need the function to run when the userform opens and I want to know if I can split the process more than twice in a single userform?

I don't really want to know or even see it, but why do you need to run 2000+ lines of code when you open a user form? Does your userform really need to be that complex? Or are you using very inefficient code?

I'm not saying I can re-write your code, but it seems like an awful lot.

The project is using 4 layers of combo boxes to sort and display different information upon a conditional request.

there are well over 200 entries per combo box. I would LOVE to have someone tell me there is a more efficient way to do this. Below is a chunk of code that the comboboxes use.

Please Login or Register  to view this content.