Custom Excel Function 1

[enirwin]

I'm creating a custom function in Excel using VBA. Does anyone know how to add variable descriptions that will display in the insert function dialog box?

Thanks.

 

[joerd]

This is not a trivial task. Laurent Longre figured it out some time ago, and published FunCustomize.dll. I don't know where I downloaded this from, but a little googling will probably help you.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[johnwm]

You can get it from several places including:

http://www.ozgrid.com/Services/ExternalFree.htm

(near bottom of page)

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[enirwin]

I found the application, but the documentation indicates that it is only set up for four functions. Is this correct? If so, is there a way to make it accept more?

Thanks.

 

[enirwin]

Disregard my previous post. I misunderstood what I was reading in the documentation. I tried it and it works perfectly and does exactly what I need.

Thanks Joerd.