Adding documentation to VBA functions.

  • Thread starter Thread starter Jacques Maartens
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top