ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Explain Parameters for a UDF (https://www.excelbanter.com/excel-programming/292547-explain-parameters-udf.html)

Juan[_3_]

Explain Parameters for a UDF
 
Hi all...

When you use the Insert Function Dialog Box to insert an
Excel Built In Function, the dialog box explains what the
function does and what each parameter of the function is
suposed to be...

How can I code this information on a User Defined Function
so tha when I use the Isert Function Dialog Box it will
explain what it does and tells the user what type of
information he should input in the formula for it to work.

Also... how do I attach a Help File with examples for a UD
Function...

Any help is highly appreciated...

Regards.
JS

Frank Kabel

Explain Parameters for a UDF
 
Hi
have a look at the following site:
http://longre.free.fr/english/
look for the Add-in FUNCUSTOMIZE.DLL

--
Regards
Frank Kabel
Frankfurt, Germany

Juan wrote:
Hi all...

When you use the Insert Function Dialog Box to insert an
Excel Built In Function, the dialog box explains what the
function does and what each parameter of the function is
suposed to be...

How can I code this information on a User Defined Function
so tha when I use the Isert Function Dialog Box it will
explain what it does and tells the user what type of
information he should input in the formula for it to work.

Also... how do I attach a Help File with examples for a UD
Function...

Any help is highly appreciated...

Regards.
JS


Juan[_3_]

Explain Parameters for a UDF
 
Thanks Frank!...this Add-In works great...

Regards
JS


-----Original Message-----
Hi
have a look at the following site:
http://longre.free.fr/english/
look for the Add-in FUNCUSTOMIZE.DLL

--
Regards
Frank Kabel
Frankfurt, Germany

Juan wrote:
Hi all...

When you use the Insert Function Dialog Box to insert an
Excel Built In Function, the dialog box explains what

the
function does and what each parameter of the function is
suposed to be...

How can I code this information on a User Defined

Function
so tha when I use the Isert Function Dialog Box it will
explain what it does and tells the user what type of
information he should input in the formula for it to

work.

Also... how do I attach a Help File with examples for a

UD
Function...

Any help is highly appreciated...

Regards.
JS

.



All times are GMT +1. The time now is 12:18 PM.

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