Run 2 macros with OnAction

[Formula11]

With a custom context menu, macro is run with ".OnAction".
See: Customizing Context Menus with VBA in every Excel version

Is there a way to run 2 macros at the same time, without creating another Sub which calls both.

 

[ranman256]

SIMPLEST WAY

sub RunBoth()
  macro1
  macro2
end sub

sub Macro1()
  beep
end sub

sub Macro2()
  beep
end sub

or put both macros in a BUTTON CLICK event.

 

[Formula11]

Thanks, but without creating another Sub.

 

[Tupe77]

Strictly speaking, VBA is single-threaded, so two macros cannot run at the same time.

On the other hand, you are talking about execution with one call, which can be done using the previous example or by calling the next macro at the end of the first macro. You could probably combine the macros, but then there is only one macro.

I would encourage you to provide more detailed information so that we can help. It would be best if you could share the macros in question here.

 

[Formula11]

Thanks for advising, in the end I just had to call another Sub which combines the 2 macros, as it looks like there isn't another option.