Run VBA Macro from VBE by name?

Run VBA Macro from VBE by name?

gerrardhickson
Collaborator Collaborator
480 Views
2 Replies
Message 1 of 3

Run VBA Macro from VBE by name?

gerrardhickson
Collaborator
Collaborator

I want to run a VBA routine by selecting one (or more) from a list of the available options - very similar to the default "Macros" Dialogue box shown below.

 

gerrardhickson_0-1636435005825.png

 

So far the best that i've come up with is to use iLogics "runVB" command, but I thought there might be a VBA native option.

 

Any suggestions?

 

 

 

0 Likes
Accepted solutions (1)
481 Views
2 Replies
Replies (2)
Message 2 of 3

Michael.Navara
Advisor
Advisor
Accepted solution
Message 3 of 3

gerrardhickson
Collaborator
Collaborator

Very nice... Extra points for finding my stack exchange post too...

0 Likes