Results 1 to 6 of 6

assistance with VBA procedure being too long

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2016
    Location
    Gilbert, Az
    MS-Off Ver
    MS 2010
    Posts
    23

    assistance with VBA procedure being too long

    so this is slightly complicated I have a worksheet named "Agents" range (A2:A21) you can enter names . I have a command button that has a macro that will create tabs based on the names entered into the range. Now I also have a worksheet "Overview" thats has the same Agent names range(B50:B69) from the Agent tab with a active X control combobox that has Jan - Dec. when you select from the drop down it should pull data from the each of the created tabs Example worksheet (Template) Range (L12:P23)

    So based on the drop down (Teamrecbox) value in the worksheet "Overview" it needs to pull the corresponding data from each of the tabs that will be created - I wrote out the code the long way but now the procedure is too long.. any assistance I can get will be amazing

    I've included a copy of my workbook
    Last edited by Sway2119; 04-17-2017 at 12:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Procedure too long
    By Littlesimon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2016, 08:02 PM
  2. some assistance adding days to long date format
    By dan_fash in forum Excel General
    Replies: 2
    Last Post: 04-10-2015, 04:10 PM
  3. [SOLVED] Procedure too long error, help with breaking down or optimizing a macro
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-19-2015, 12:00 PM
  4. VBA Ok Click() If Statement Procedure Too Long
    By LukeAM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2014, 06:59 AM
  5. [SOLVED] Help needed simplifying code as procedure to long
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-28-2014, 10:55 AM
  6. Excel 2010: Macro Error 'Procedure Too Long'
    By marthadanielle in forum Excel General
    Replies: 4
    Last Post: 04-13-2012, 07:15 AM
  7. Procedure Too Long
    By Nick3535 in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 10-08-2010, 09:02 PM

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