View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default 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.