Discussion Locked

Excel User-defined Functions

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When creating UDFs for use by others, how does one define the argument descriptions for page 2 of the Paste-function wizard?

4 replies

by dklippert

There might/must be an easier way.

Change the code from Function Mfred() to Sub Mfred(). Then use the macro Option box to add a description or run a macro like this:

Sub MacroDesc()
Application.MacroOptions _
Macro:="Module1.MFred", Description:= _
"Adds two cells a bunch of times"
End Sub

Change the code back to Function Mfred()

by noonan

I am able to describe the function, if you open the function properties under ObjectBrowser you can add a definition. I need to add descriptions to the arguments that would be entered on page 2 of the paste-function wizard.

by noonan

I apologize for taking so long too respond. I have been investigating the sites and the code examples in them. Unfortunately, I am not familiar with Excel4Macros (I know they go on a macro sheet) Perhaps you would like to construct a sample workbookfor my perusal. (You want the points, I want the answer!)Appreciate your efforts to date - They have introduced a couple of interesting sites.

This discussion is closed to new replies.