procedure too large

  1. J

    Procedure too large - VBA - Userform

    Hello, new member here! I'm beginning with VBA and I've runned in a new problem with my code. I have a userform with about 610 textboxes which values are copied in a column in a database. If I enter new data the code works well, but if I want to edit I get this error message "Compile Error...
  2. D

    VBA procedure too large

    hi Guys, I have a huge worksheet with a lot of code in it, but everytime i run it, it gives me an error saying the procedure is too large. Is there a work around it? the code is 4000 lines, but most of it is the same thing with the only difference being either the table name, column name, or...
  3. C

    Procedure Too Large

    I have simple but long code as below. I am getting error saying that "Procedure too large". Can someone tell me how to make it shorter or split it? Appreciate and thanks in advance. Option Explicit Private Sub cmdCancel_Click() Unload Me End Sub Private Sub cmdOK_Click() Dim LColumn As...
  4. C

    Compile error

    When running my macro I received a compile error stating the procedure is too large. Does this error mean there are too many formulas for this macro? How do I fix it?
  5. A

    VBA Select Case error: procedure too large

    Hi, I have 30 different cases working well in one module so far. Now I need to add some more cases, but the system doesn’t allow me to start defining any new cases under Select – Case, it shows: compile error: procedure too large. I’m thinking maybe there’s a way to combine multiple cases...
  6. C

    Procedure Too Large - I know I should condense it, but I don't know how...

    Hi there Excel Wizards, I wonder if you can help me with a problem I'm having. I'm creating a heat map in Excel, and after many months of struggle I've managed to source the code. When I've put it together in VBA (of which my knowledge is zero), I get a Procedure Too Large message. I've...
  7. S

    Macro procedure too large.... how can I shorten?

    My spreadsheet has a specific macro embedded in it that I want to run many times (the command sets several items in the current row on spreadsheet, and then jumps to next row). I set up my own macro to run the command many times in succession (for many rows). It sets calculation to Manual...
  8. Y

    Excel VBA: Procedure too large - doomed?

    I received a "procedure too large" error which, according to web search result, can be solved by splitting codes into smaller subroutines. In my case, I don't know how to do it. My error occurs in "select case". I have more than 200 cases to process. Any idea how to split cases into smaller unit?
  9. I

    Procedure Declarations Equal to Initialize and Activate

    :confused:What is a procedure that acts the same as Userform_Initialize() and Userform_Activate()? I have tried typing my own as Userform_Initialize2() but it does not work. I just need another procedure that will run when the form is opened other than those 2. Please help. imav
  10. N

    Procedure too large - how can I shorten my code?

    I have written a macro to work from an command button to update sales reports. This command button will update the master sheet, then create, rename and save etc individual files to be emailed out to the sales guys. The code is now too long as I am still quite new to using visual basic I do...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back