Launch VBA form from toolbay buttom

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Santos P - 09 Feb 2006 16:45 GMT

I have made a VBA program & exported it out to a .frm. Is there a way to
create a toolbar button to run the .frm which in turn would run the code in
the background?

Reply to this Message

Jonathan West - 09 Feb 2006 16:57 GMT

>I have made a VBA program & exported it out to a .frm. Is there a way to
> create a toolbar button to run the .frm which in turn would run the code
> in
> the background?

No. The form would have to be in a template or add-in, and called from a
macro. The OnAction property of a button specifies which macro is run.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message