Not sure if this falls inder Excel VBA or not but,

Is it possible to add formula (ie create them) to the list of formula that comes with Excel?

Thanks!

This topic falls under VBA.

When you have created a formula it will appear under the User Defined category in Excel. The User Defined category will only appear when a formula is created.

You create a formula in VBA using Function and End Function instead of Sub in your procedure.

I am also interested in this topic.
I created a function but I cannot see it in the User Defined category. What can be the reason?

Mihai B
[email protected]

Hi,

UDF functions must be created to modules not in the Excel objects (Thisworkbook etc.)

-vemaju

Thanks! It works now.