Hi All,

I am designing my own functions and was wondering how I add the “Help”
text that appears at the bottom of the grey box you see when you double
click the funtion name.

EG for the =sum function you see “Adds all the numbers in a range of
cells”. Below this there is also text giving information on each
argument.

Hos do I code this?

Regards
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=515629

You can add a description for your function. Try this. Hit Alt-F8 (or
however you bring up the Macro box,) since you are dealing with a function,
its name won't appear so you have to type it in. When you do, you should be
able to choose Options. Click Options and enter your description. However,
last I heard there is no way to give help for your argument list.

--
Kevin Vaughn


"Gazzr" wrote:

>
> Hi All,
>
> I am designing my own functions and was wondering how I add the “Help�
> text that appears at the bottom of the grey box you see when you double
> click the funtion name.
>
> EG for the =sum function you see “Adds all the numbers in a range of
> cells�. Below this there is also text giving information on each
> argument.
>
> Hos do I code this?
>
> Regards
> Garry
>
>
> --
> Gazzr
> ------------------------------------------------------------------------
> Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
> View this thread: http://www.excelforum.com/showthread...hreadid=515629
>
>