+ Reply to Thread
Results 1 to 3 of 3

two macros run at same time

  1. #1
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    251

    two macros run at same time

    dear team,
    i create the code automatically send mail to my team, there is two module but its not going automatically when i press f5 then its asking me which macros will run.
    now i want to run the macros will automatically in same two modules in time?

    thanks

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: two macros run at same time

    As far as I know it is not possible to run multiple macros from the same instance of Excel and I would not recommend attempting to run multiple instances/multiple macros. I cannot think of a single good reason to need to run 2 macros at literally the same time (you may have a sequence of macros triggered/initiated at the same time by the user, which is very different). So for example you may run macro1, which in turn runs macro2, which runs macro3, etc. It can even be that macro2 runs, completes and then macro1 continues beyond that. There however is no good reason to attempt having macro 1, 2 and 3 all execute at exactly the same time.

    We have no context on what your macro does, what your data sets look like, the code or have any sample files to make a judgment from. F5 is typically the shortcut for goto, so it appears the macro has likely been coded to use this shortcut, in which case it is likely a requirement to get user input for it to run properly. Again, speculation without any context.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

  3. #3
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    251

    Re: two macros run at same time

    there is sheets1 is birthday date and sheets2 is festival dates
    this my code this give me any solution

+ 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. Can I run two macros in the same time?
    By emil in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-11-2020, 08:03 AM
  2. Replies: 2
    Last Post: 04-13-2017, 02:57 AM
  3. How to fix time with macros
    By osamajamal in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-24-2013, 03:46 AM
  4. How do I run DDE and Macros at the same time?
    By Caleb Chia in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-23-2010, 01:52 AM
  5. on time to run 2 macros and pop up box
    By jamiepullen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2008, 04:11 PM
  6. [SOLVED] Can I run two macros in the same time?
    By emil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2006, 02:55 PM
  7. Run two macros in the same time.
    By emil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2006, 02:45 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