Sharing custom forms

  • Thread starter Thread starter ChrisJForeman
  • Start date Start date
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
 
Chris
From the VBA editor you can export a form which creates 2 files (.frm .frx)
that can be imported into new applications.

Cheers
N
 
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
 
Back
Top