Adding documentation to VBA functions.

J

Jacques Maartens

Hi

How do I add documentation/desriptions for VBA functions or function
variables?

I have tried to add a description to a function's properties under its
Memeber Options in VBA but the description is not displayed when the
function is called in MS Excel.

Jacques
 
B

Bob Phillips

Jacques,

You need Laurent Longre's FUNCUSTOMIZE utility .Get it at
http://longre.free.fr/english/


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
N

Norman Harker

Hi Jacques!

To add a description of the function use:

Tools > Macro > Macros
Select or type the function names
Options
Type a description.

Also within the VBE use the object browser to look at the xla, then
select your function and right click on it and select properties.
Enter your description there.

Adding argument descriptions isn't supported very well but you can
take a look at:

http://longre.free.fr/english/func_cats.htm

http://longre.free.fr/english/index.html#FunCustomize


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top