UDF with user help
It works fine in my Excel 2000. There is another way though.
Export the module and open from file in a text editor.
After the function name include the description attribute, eg
Function foo(arg)
Attribute foo.VB_Description = "first line of info\r\nSecond line more info"
' your code
End Function
The \r\n in the string will force a new line (max 2 lines in xl97, 3 in
later versions) or just allow to wrap.
Save and import back into your project (drag from file) after removing the
old bas.
Regards,
Peter T
"Bill Renaud" wrote in message
. ..
<<Something quick and simple that you could do, although far from
complete,
is to add a description that can be viewed after user finds your UDF in
the
"User Defined" category
Hopefully this feature works in later versions of Excel! In Excel 2000
(SP-3), Excel just throws the Description field away after the programmer
enters it in the Member Options dialog box!
--
Regards,
Bill Renaud
|