Sharing UserForms/Macros

[bpottberg]

I have created a userform to calculate the number of shares in a mutual fund from the % of total holdings. How can I share this with my colleagues?

Thank you

 

[Dave Hawley]

Hi bpottberg

Best way would be to save it as an Add-in (*lxa) then install it like a standard Excel add-in, eg Tool>add-ins | Browse

 

[bpottberg]

Thanks,

I have saved it as an add-in and opened a new WB and included it, but....

How can this be called from the workbook?
As you can tell I am relatively new to this.

Tks.