Results 1 to 3 of 3

VBA Multiple Process Splits

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    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?
    Last edited by imav; 07-21-2011 at 01:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1