Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List Modules in a user form | Excel Programming | |||
VBA & User Form modules vanish | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
Scope of variable includes all Form _and_ Code modules?? | Excel Programming |