PDA

View Full Version : [SOLVED] Guide for VBA functions



ALe
09-07-2005, 06:46 AM
Hello!

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

Thanks

mvidas
09-07-2005, 07:53 AM
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
09-07-2005, 09:40 AM
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
09-07-2005, 09:41 AM
sorry, I read mark instead of mvidas

Zack Barresse
09-07-2005, 09:57 AM
You need to create that on your own. Check out this site by MS MVP Laurent Longre ...

http://xcell05.free.fr/


(Hey Matt!)

mvidas
09-07-2005, 10:34 AM
Hi Zack! Nice link, I'm going to keep that one handy :)

Zack Barresse
09-07-2005, 10:36 AM
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
09-07-2005, 10:41 AM
This site is wonderful and the addin is exactly what I was looking for. Thanks a lot fyrefytr!!

MOS MASTER
09-07-2005, 10:59 AM
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? :dunno

Zack Barresse
09-07-2005, 12:59 PM
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
09-07-2005, 01:03 PM
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.....:whistle:

MOS MASTER
09-07-2005, 01:10 PM
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! :rofl:

I'm such a slow nimwith at times :moosegrin

Zack Barresse
09-07-2005, 01:27 PM
Add-in is up! Check out the Cool Tools (http://www.vbaexpress.com/cooltools.php) page for Parry's Format Function add-in. :)

MOS MASTER
09-07-2005, 01:30 PM
Add-in is up! Check out the Cool Tools (http://www.vbaexpress.com/cooltools.php) page for Parry's Format Function add-in. :)

Sweet! :giggle

Zack Barresse
09-07-2005, 01:36 PM
And stickied! http://vbaexpress.com/forum/showthread.php?t=5075

ALe
09-08-2005, 12:06 AM
Great firefytr, I'll check the add-in! I'm marking this thread as solved. Thanks a lot!