creating my own formula and save it as add-in

[AG]

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]

Copious notes and examples on Chip Pearson's site:

http://www.cpearson.com/excel/WritingFunctionsInVBA.aspx

Browse around other parts of his site as well.

Hope this helps.

Pete