View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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