How to turn a user form into an add-in

  • Thread starter Thread starter akh2103
  • Start date Start date
A

akh2103

I have created a userform that is a crucial part of a macro that I want
to use many times in many workbooks. When I create a special toolbar
with a button assigned to the macro, excel doesn't know to bring along
the userform and I get an error message. How do I install the userform
as an add-in and connect it to my macro? Thanks. -Abe
 
Abe, To make your userform an add-in make sure you need to set the
workbook add-in property to True. To do this, launch VBEditor. Press
F4 to open the Properties box and then choose Thisworkbook for the
workbook the Userform is in. Find IsAddin and set it to true.

Then put your menu building code in that workbook to where it creates
the menu when the add-in is launched (auto_open) and install the add-in
in Excel.

If you dont want to build the menu you could setup a hotkey to launch
the Userform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems adding botton to a menu bar 3
closing another file by code causes failure to run workbook activate event 2
How to enumerate buttons on user form 2
Send Email(s) by selecting users from user form 1
Must something be done to a userform? 2
Help. where's the #@%$&^ userform? 7
How to call module function or sub from the Add In? 3
Save workbook button on Userform 2

Back
Top