Creating my own user defined function help statements
 

Hi,

Can you please provide an answer to the following question:

How do I program in help statements to go with my user defined function that
I creat in VBA? (The help statements would be displayed in the function
argument box, like the regular Excel functions have...explaining to the user
what each argument (and the whole function) purpose is.

Also, in a related note, how to I get function tool tips to appear with my
custom function like the regular functions provide when you type them
directly in a cell.

thank you very much

Craig

Creating my own user defined function help statements
 

Hi Craig,

Look he

http://www.dicks-blog.com/archives/2...on-with-excel/

--
Kind regards,

Niek Otten

"Craig" wrote in message
...
Hi,

Can you please provide an answer to the following question:

How do I program in help statements to go with my user defined function
that
I creat in VBA? (The help statements would be displayed in the function
argument box, like the regular Excel functions have...explaining to the
user
what each argument (and the whole function) purpose is.

Also, in a related note, how to I get function tool tips to appear with my
custom function like the regular functions provide when you type them
directly in a cell.

thank you very much

Craig

Creating my own user defined function help statements
 

Thanks very much this is great!!

"Niek Otten" wrote:

Hi Craig,

Look he

http://www.dicks-blog.com/archives/2...on-with-excel/

--
Kind regards,

Niek Otten

"Craig" wrote in message
...
Hi,

Can you please provide an answer to the following question:

How do I program in help statements to go with my user defined function
that
I creat in VBA? (The help statements would be displayed in the function
argument box, like the regular Excel functions have...explaining to the
user
what each argument (and the whole function) purpose is.

Also, in a related note, how to I get function tool tips to appear with my
custom function like the regular functions provide when you type them
directly in a cell.

thank you very much

Craig