ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   creating my own formula and save it as add-in (https://www.excelbanter.com/excel-discussion-misc-queries/183763-creating-my-own-formula-save-add.html)

AG[_2_]

creating my own formula and save it as add-in
 
Hi
How can I create my own formula (using VB editor) and then save it as
add-in?
i.e.
i want to write a VB code that after I'll save it, it will have a name
and act as all the Excel formulas (that I could click with my mouse on
the Fx, find this formula, fill in the parameters I programed and so
on)

Thanks

Pete_UK

creating my own formula and save it as add-in
 
Copious notes and examples on Chip Pearson's site:

http://www.cpearson.com/excel/Writin...ionsInVBA.aspx

Browse around other parts of his site as well.

Hope this helps.

Pete

On Apr 15, 3:39*pm, AG wrote:
Hi
How can I create my own formula (using VB editor) and then save it as
add-in?
i.e.
i want to write a VB code that after I'll save it, it will have a name
and act as all the Excel formulas (that I could click with my mouse on
the Fx, find this formula, fill in the parameters I programed and so
on)

Thanks




All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com