User Defined Functions
 

i know how to make a custom defined function
but what i really want to know how can i make it a a normal function
in other word when you insert a normal functrion and when you step in each
textbox it show a brief description about the box you are in

how can i make this in a user defined function

User Defined Functions
 

I don't believe you can define each box, but here is a work around...

Go to Tools | Macros
Type in your UDF Name
Click Options
Enter information into the Decription box

--
Thx
MSweetG222



"Walid M. Bahgat" wrote:

i know how to make a custom defined function
but what i really want to know how can i make it a a normal function
in other word when you insert a normal functrion and when you step in each
textbox it show a brief description about the box you are in

how can i make this in a user defined function

User Defined Functions
 

I re-read your post. Maybe you are asking how to make it an XLL?

--
Thx
MSweetG222



"MSweetG222" wrote:

I don't believe you can define each box, but here is a work around...

Go to Tools | Macros
Type in your UDF Name
Click Options
Enter information into the Decription box

--
Thx
MSweetG222



"Walid M. Bahgat" wrote:

i know how to make a custom defined function
but what i really want to know how can i make it a a normal function
in other word when you insert a normal functrion and when you step in each
textbox it show a brief description about the box you are in

how can i make this in a user defined function

User Defined Functions
 

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Walid M. Bahgat" wrote in message
...
| Thanks for your care
| but as for example i'll make a function named XYZ
| it takes cell1 and cell2
| i want when he put the cursor in cell1 box i want him to give a brief
| description at the bottom of the function wizard
|
| "Walid M. Bahgat" wrote:
|
| i know how to make a custom defined function
| but what i really want to know how can i make it a a normal function
| in other word when you insert a normal functrion and when you step in each
| textbox it show a brief description about the box you are in
|
| how can i make this in a user defined function