ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I create a function into function list? (https://www.excelbanter.com/excel-programming/328024-how-do-i-create-function-into-function-list.html)

Hossein Farhani

How do I create a function into function list?
 
I had written a function , so I want to add it in function list . can I do
this or not?
please answer me soon.
thanks a lot.

Toppers

How do I create a function into function list?
 
Your function(s) will appear in the "User Defined" category in the standard
functions list. This category is at the bottom of the category list.

If functions are to be shared among workbooks, put them in your
Personal.xls workbook.

HTH

"Hossein Farhani" wrote:

I had written a function , so I want to add it in function list . can I do
this or not?
please answer me soon.
thanks a lot.


Tom Ogilvy

How do I create a function into function list?
 
The function should be placed in a general module and not declared as
Private in addition.

Not in a sheet module and not in the Thisworkbook module

If the function is to be shared, personal.xls is one choice, but you might
also want to consider putting it in an Addin. Then you won't have to
preface the function with the workbook name when you try to us it. (the
addin will need to be loaded).

--
Regards,
Tom Ogilvy

"Toppers" wrote in message
...
Your function(s) will appear in the "User Defined" category in the

standard
functions list. This category is at the bottom of the category list.

If functions are to be shared among workbooks, put them in your
Personal.xls workbook.

HTH

"Hossein Farhani" wrote:

I had written a function , so I want to add it in function list . can I

do
this or not?
please answer me soon.
thanks a lot.





All times are GMT +1. The time now is 10:38 PM.

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