LinkBack URL
About LinkBacks
Hi, im new to VBA. How can I do a popup, which asks what macro i want to run. I want the two possibilities in 1 macro like this:
Sub Test()
blabla
If user selects macro 1, Do this code:
blabla
If user selects macro 2, Do this code:
blahblah
End Sub
VBA Select which macro to run, all in one macro.
Hi, im new to VBA. How can I do a popup, which asks what macro i want to run. I want the two possibilities in 1 macro like this:
Sub Test()
blabla
If user selects macro 1, Do this code:
blabla
If user selects macro 2, Do this code:
blahblah
End Sub
Last edited by stupsi01; 01-04-2017 at 06:39 AM. Reason: Solved
Something like
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi!
Lets say you have two sub routines:
Now you need to run one of them:Please Login or Register to view this content.
Please Login or Register to view this content.
@kasan
Thanks, that worked. How can I change vbYesNo to a specific text such as Macro 1, Macro 2?
Last edited by stupsi01; 01-03-2017 at 11:22 AM.
@mikerickson
Hi, thanks that worked. Can I do that with just one "text" in the field? Like so:
What macro do you want to start?
Macro1 Macro2
@stupsi01
MsgBox is simple, build-in solution. And its standart.
In case you want buttons named Macro1 and Macro2 - userform shold be used. Userform will allow you to make many buttons and name them as you wish.
Here is simple example of two custom buttons.
Last edited by kasan; 01-03-2017 at 03:58 PM.
No, the captions of a MsgBox are fixed and cannot be customized.Originally Posted by stupsi01
Hi,
You can use InputBox rather then MsgBox. You might also use Application.Run if they will be entering the name of a macro to run.
It is in fact possible to alter the captions of the MsgBox buttons but it requires API callbacks.
Last edited by xlnitwit; 01-04-2017 at 02:55 AM.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks