XLL: UDF Function parameter as select list

Add-in Express™ Support Service
That's what is more important than anything else

XLL: UDF Function parameter as select list
Picking a parameter-value from a pre-defined list of possible values 
Ernst Kuschke




Posts: 20
Joined: 2011-08-10
Hi,

I want to create a UDF function that has one parameter that could be one of a few pre-defined values. A simple example:

- double GetStockQuote(string symbol, ExchangeEnumeration exchange)

Is it possible to have the user sel ect the 2nd parameter fr om a drop-down list?

Thanks for any help,

Ernst
Posted 19 Sep, 2011 04:26:44 Top
Andrei Smolin


Add-in Express team


Posts: 14107
Joined: 2006-05-11
Hi Ernst,

As far as I know, it isn't possible to do in the Excel UI. Besides, the UI allows the end user to bypass this by editing a formula in the Formula Bar. That is, you cannot make the user use any specific way.

But you can use a pane to simplify the way the user creates and inserts such a formula.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 19 Sep, 2011 05:11:55 Top
Ernst Kuschke




Posts: 20
Joined: 2011-08-10
Thanks. I'll use a pane...
Posted 20 Sep, 2011 11:15:39 Top