Breaking User Form Code into modules question
I have a user form with alot of code in it. As of now all the code is in the
Userform
Code window, but there is so much code that it's getting confusing. I have
one Sub that is to large and needs to be split into several subs.
When I was done I was going to break all the Subs down into different
modules to clean it up. I guess I will have to do that now, but I am not sure
how to do it.
1: My question is in the UserForm Code Window how do I refer to a module?
2: If the Code is to large can one Module call another module?
Something like User form Code calls Module 1 and at the end of module 1
code, it calls for module 2, etc....
3: Most of my Code is With statements / End With then more code.
Here is an Example of the Code in the UserForm Code Window:
Private Sub Update_Installer_Forms_10_Click()
With Workbooks("Master Installer Forms.xlsm").Sheets("Install Pack Con")
**Code for the sub is here**
End With
With Workbooks("Master Installer Forms.xlsm").Sheets("Install Chk List")
**Code for the sub is here**
End With
End Sub
I really need to sort this out so it's not so confusing to work on. Can
anyone please help me or explain it in english to me.
|