+ Reply to Thread
Results 1 to 7 of 7

Run (Call) Three Other Macros depending on values found

  1. #1
    Registered User
    Join Date
    07-20-2015
    Location
    New York
    MS-Off Ver
    2305 - Enterprise 365
    Posts
    147

    Run (Call) Three Other Macros depending on values found

    Hello All,
    I have attached a workbook with three different worksheets showing three different possibilities. In all three instances, the macro should take me to a different macro and run it (call it) depending on the values found in the spreadsheet. In the first scenario, the macro (let's name it "macro test") finds both "A" (xlWhole) and "P" (xlWhole) in column E. Therefore, macro test should call Macro "Both". In the second scenario, macro test finds only "A" (xlWhole). Therefore macro test should call Macro "A". In the third scenario, macro test finds only "P" (xlWhole). Therefore macro test calls Macro "P".

    Macro test ends upon calling any of these three macros.

    I look forward to your reply.

    Best,
    Andrewstupendo
    Attached Files Attached Files
    Last edited by Andrewstupendo; 04-24-2018 at 06:58 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Run (Call) Three Other Macros depending on values found

    You forgot to include the code you were working on
    Last edited by protonLeah; 04-24-2018 at 08:34 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-20-2015
    Location
    New York
    MS-Off Ver
    2305 - Enterprise 365
    Posts
    147

    Re: Run (Call) Three Other Macros depending on values found

    There is no need for the other coding that I am working on.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Run (Call) Three Other Macros depending on values found

    Looks like that workbook took about 10 - 15 seconds to drag fill...
    How much time should others invest if you don't?

    Maybe you should post in the Commercial services section and pay.
    Last edited by protonLeah; 04-24-2018 at 08:37 PM.

  5. #5
    Registered User
    Join Date
    07-20-2015
    Location
    New York
    MS-Off Ver
    2305 - Enterprise 365
    Posts
    147

    Re: Run (Call) Three Other Macros depending on values found

    Maybe I should. How many points would such a macro cost?

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Run (Call) Three Other Macros depending on values found

    One way.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  7. #7
    Registered User
    Join Date
    07-20-2015
    Location
    New York
    MS-Off Ver
    2305 - Enterprise 365
    Posts
    147

    Re: Run (Call) Three Other Macros depending on values found

    Thank you, Tinbendr. I will work on this as soon as I can. Best, Andrewstupendo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merge macros found online need tweaking
    By BDD2015 in forum Excel General
    Replies: 4
    Last Post: 01-29-2018, 10:49 AM
  2. [SOLVED] How to identify values that are found in variable_1 but are not found in variable_2?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-26-2017, 10:55 AM
  3. Replies: 3
    Last Post: 12-31-2015, 11:17 AM
  4. Check for values in a table and if found add value found in column to left to list
    By robhargreaves in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2013, 02:57 PM
  5. Replies: 4
    Last Post: 01-10-2013, 08:25 PM
  6. [SOLVED] Outputting different values depending on which text value of multiple is found in a string
    By RichieAHB in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-15-2012, 12:15 PM
  7. Macros (Sub routine type) not found, Functions are In XLA
    By Andy Kessel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2006, 02:10 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