Guide for VBA functions

[ALe]

Hello!

I was wondering how it is possible to use the Functions Guide of Excel for the functions I create in VBA.

Thanks

[mvidas]

Hi ALe,

I'm assuming you're referring to the dialog that prompts users for input. To use this for any UDF that you make, simply enter =functionname( in a cell, and press control-a.

As an fyi, if it is the first time you're using the function from the worksheet, if you enter the name in caps, ie. =FUNCTIONNAME( and press control-a, the function will always be capitalized for each future use of it.

Matt

[ALe]

Thanks Mark, I was referring to that dialog.
What I'd like to have is a description of the variables of the function and the preview result as excel shows for a normal function (like sum, average,...)

[ALe]

sorry, I read mark instead of mvidas

[Zack Barresse]

You need to create that on your own. Check out this site by MS MVP Laurent Longre ...

http://xcell05.free.fr/


(Hey Matt!)

[mvidas]

Hi Zack! Nice link, I'm going to keep that one handy

[Zack Barresse]

I've got an add-in by Graham Paramore (parry) which he utilizes it. I've got to upload it to the server (had it a month ago, but lost the emails in the server switch) as he graciously agreed to let me publish it here at VBAX. It's a WONDERFUL add-in. I'll be making a post about it soon.

[ALe]

This site is wonderful and the addin is exactly what I was looking for. Thanks a lot fyrefytr!!

[MOS MASTER]

Hello!

I was wondering how it is possible to use the Functions Guide of Excel for the functions I create in VBA.

Thanks

Must be misunderstanding the question but isn't it as simple as:

• To use your User Defined function, click Insert Function on the Insert menu.
• In the Insert Function dialog box, click User Defined under Categories, and then click (Name of your function) under Select a function. Click OK.

Am I missing something here?

[Zack Barresse]

Joost, click on the link I provided, then click on the 'English' link. It shows a screen shot of (what I think) the OP is asking for.

[MOS MASTER]

Joost, click on the link I provided, then click on the 'English' link. It shows a screen shot of (what I think) the OP is asking for.

Ok I must be totaly off now!

I'm talking about the same thing I think? Using a UDF from the Function Dialog to insert it from that Dialog?

Must be me.....

[MOS MASTER]

Ok I think I got it now testing that Add-in.

The Op wants custom help text with his function to aid in using them!

I'm such a slow nimwith at times

[Zack Barresse]

Add-in is up! Check out the Cool Tools page for Parry's Format Function add-in.

[MOS MASTER]

Add-in is up! Check out the Cool Tools page for Parry's Format Function add-in.

Sweet!

[Zack Barresse]

And stickied! http://vbaexpress.com/forum/showthread.php?t=5075

[ALe]

Great firefytr, I'll check the add-in! I'm marking this thread as solved. Thanks a lot!