General discussion

Locked

Excel User-defined Functions

By noonan ·
When creating UDFs for use by others, how does one define the argument descriptions for page 2 of the Paste-function wizard?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel User-defined Functions

by DKlippert In reply to Excel User-defined Functi ...

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()

Collapse -

Excel User-defined Functions

by noonan In reply to Excel User-defined Functi ...

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.

Collapse -

Excel User-defined Functions

by DKlippert In reply to Excel User-defined Functi ...

I think I've found an answer. I'm glad you asked the question, Ill be able to use this too. You'll have to fiddle with the code, of course.

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

also

http://groups.google.com/groups?oi=djq&selm=an_664661314

or Longre's "Power Programming Techniques" in:

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


(no spaces or %20 in URL)

Collapse -

Excel User-defined Functions

by noonan In reply to Excel User-defined Functi ...

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.

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Software Forums