What I'm trying to do is to cause a user input form I created to appear, and
then the data on the spreadsheet is processed according to the variables
input by the user. I guess where I'm having a problem is to make the form
appear ("run"). I'm able to do this by going to the VB editor, viewing the
form, and hitting run, but I'm hoping to make this a little easier for the
user....
--
Byron M


"Randy Harmelink" wrote:

An add-in is really nothing more than a collection of subroutines
(i.e. macros) and/or functions. You don't really "run" it.
Typically, you would make it active via the Tools Add-Ins menu
option. From that point, you can run any of the macros or use any of
the functions within the add-in.

As far as the add-in creating command buttons or menu items, you'd
need to have something in the workbook being opened that would utilize
those macros within the add-in to do the creation. Say, within the
workbook open event. Or you could manually create a button on your
worksheet that uses a macro *from* the add-in.

I suppose you could put the add-in in the XLSTART directory to have it
automatically generate menus and the like, but I'm not sure I'd want
it to do that.

Byron M wrote:
I've created some VB code and turned it / saved it as an Add-In. Now I want
to be able to run the code from other worksheets. How to do it? Ideally,
when the add-in is loaded, it would create a command button or menu item
which the user then selects to run the add-in.

Note I am not an advanced coder / user....

Suggestions welcome!