+ Reply to Thread
Results 1 to 2 of 2

Multiple macros for one work sheet

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Minneapolis, MN
    MS-Off Ver
    Minnesota
    Posts
    13

    Multiple macros for one work sheet

    I want to be able to call multiple different macros with different limits for each cell in one worksheets. So for example:

    If A2 is more than 500, call macro1
    If A3 is more than 400, call macro2
    If A4 is more than 800, call macro3

    Can't seem to figure this one out.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Multiple macros for one work sheet

    Am no VBA expert but
    just write one macro with three different routines

    Please Login or Register  to view this content.
    or replace each

    ...
    ...
    ...
    with a call to each routine

    Depends on complexity of each macro
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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] Renamed Excel sheet - Macros do not work
    By Reggie Wells in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-07-2017, 03:29 PM
  2. Macros stop to work when work sheet is protected. Run time error 1004
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 01:14 AM
  3. Replies: 2
    Last Post: 07-31-2012, 04:22 PM
  4. Get macros to work on protected sheet
    By howsitgoing in forum Excel General
    Replies: 4
    Last Post: 01-12-2012, 02:10 PM
  5. Two macros on one sheet don't work well together
    By alina_t in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2011, 11:03 PM
  6. Macros to work upon opening workbook + only on one sheet
    By mitts in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2011, 10:04 AM
  7. Macros that only work on one sheet
    By drgogo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2009, 03:55 AM

Tags for this Thread

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