PDA

View Full Version : Solved: VBA To Run Macro From Menu Button



jo15765
02-28-2012, 08:37 PM
I found this site that shows me how to use VBA to create a custom button on a custom menu. My question now is how to use VBA to put a macro behind that button, or to have an onclick() event for that button?

http://scriptorium.serve-it.nl/view.php?sid=14

TMShucks
03-03-2012, 11:01 AM
The .onaction parameter sets the macro to be called. In the example, it is: SubItWorks


Regards

jo15765
03-05-2012, 07:35 AM
Thank you for the prompt reply!! This answer got me through what I was working on!!!! Apologies for the delay in responding/marking as solved.

TMShucks
03-05-2012, 04:26 PM
You're welcome.