Sharing custom forms

C

ChrisJForeman

I have just started experimenting with VBA and have created a custom form. It
is a fairly basic input form, invoked by a button on a custom toolbar and could
almost have been done using the Form facility. My question is: where can I put
this form and its associated code so that it is shareable by other workbooks.
My instruction book, which has got me this far does not seem to cover libraries
- or are they called something else in Excel?

TIA

Chris
 
G

Gord Dibben

Chris

I would be tempted to place the code and Form into an Add-in which would be
available for all workbooks.

ALT + F11 to open VBEditor

Export the Form and Module via R-click>Export to a folder of your choice.

Then, in Excel, Close the original workbook and File>New>Workbook.

ALT + F11 to open VBEditor.

Select your workbook/project and r-click>Import the Form and Module.

Back to Excel and File>Save as>save as Type>MS Excel Add-in(*.xla)

Give it a nice name like MyMacros or similar.

Load the Add-in through Tools>Add-ins

You can keep adding new macros and Forms to this Add-in.

Also handy if you want others to share the Macro and Form. Just ship them the
MyMacros.xla

Gord Dibben XL2002
 
Top