How do I display "Help" Text in my own functions
 

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

How do I display "Help" Text in my own functions
 

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