custom function parameter assistance

[jbesant]

Hi there,

I built a custom function in vba.

When called from a cell in excel, I want the parameters to pop up to assist the user as they would for a built-in excel function.

Is there a way to do this?

Example of kind of function I'm talking about:
function test (hello as Integer) As variant
hello = hello *2
End Function

Thanks so much!
Jamie

 

[paipimenta]

Function test (hello As Integer) As variant
test = hello *2
End Function

As far as the parameter hints, here's the best I could find, but deals mainly with the Insert Function dialog...
http://www.dailydoseofexcel.com/archives/2006/02/17/registering-a-user-defined-function-with-excel/

Although, the test function showed up in the Insert Function dialog for me, and it showed Hello as the first and only parameter, so I'm not sure why it's not showing up when I type in "=test(" in a cell, nothing hints me.

I'm guessing this is a pretty ugly fingers-in-Excel's-brain operation that may require an add-in to be loaded to do this to each computer with Excel you want to be affected.

 

[swinglow]

I think it's possible only in 2010:

http://spreadsheetpage.com/index.php/tip/C32