help for functions 1

[rgandy]

does anyone know a simple means of developing help for functinos? i want to allow the user to know what should be input in each argument
i cannot seem to find any good info on this specific topic

for example
rectanglearea(height, width)

i want user to see in the function dialog box
when selecting height
"represents the height of the rectangle"

when selecting width
"represents the width of the rectangle

 

[fumei]

There is a function dialog box?

Gerry

 

[rmikesmith]

rgandy,

Check out the method demonstrated by Microsoft Excel MVP Laurent Longre in Issue 9 of the Excel Experts E-Letter, currently hosted on John Walkenbach's Spreadsheet Page website. Here is the link:

http://www.j-walk.com/ss/excel/eee/eee009.txt

Scroll down to Power Programming Techniques near the end.

The main point is to register UDF's with Excel under custom function categories but it looks like there is the ability to include simple parameter descriptions. This may be what you need.


Regards,
Mike

 

[rmikesmith]

Adding to my previous reply: Laurent Longre has a free Excel Add-In, FUNCUSTOMIZE.DLL, that encapsulates the functionality indicated above. May be worth checking out. Here is the link:

http://xcell05.free.fr/english/

Regards,
Mike

 

[rgandy]

thanks for all your help guys

 

[rmikesmith]

If you're interested, some further discussion on this topic/solution is at:

http://www.dailydoseofexcel.com/archives/2006/04/13/registering-a-udf-take-2/

Regards,
Mike