Writing functions to prompt for info

[Conan Kelly]

Hello all,

Do you all know how Excel shows a ToolTip (I guess you could call it)
showing you which arguments need to be entered?

Is there any way I can get my own UDF's to do the same thing?

Can I get my UDF to work with the Insert Function dialog box and the
Function Arguments dialog box?

Thanks for any help anyone can provide,

Conan Kelly

 

[Niek Otten]

Hi Conan Kelly,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello all,
|
| Do you all know how Excel shows a ToolTip (I guess you could call it)
| showing you which arguments need to be entered?
|
| Is there any way I can get my own UDF's to do the same thing?
|
| Can I get my UDF to work with the Insert Function dialog box and the
| Function Arguments dialog box?
|
| Thanks for any help anyone can provide,
|
| Conan Kelly
|
|