User Defined Functions: can control what named ranges get used?

**djt76010** · 11-21-2008, 08:07 PM

I am writing custom functions for other people in my office to use as an add-in, with one of the key variables being a named range. Is it possible to add something along the lines of a List Box or a Combo Box so that I can control what named ranges get used?

Thanks

**shg** · 11-21-2008, 08:09 PM

You could use an InputBox and allow people to choose from a list of ranges. But is if really is a UDF and not a sub, that's a very bad idea, becase the UDF will only recalculate when one of its passed arguments changes.

**djt76010** · 11-21-2008, 08:18 PM

Oops . . . I wasn't quite clear. I was looking to add a List or Combo Box to the "Function Arguments" box that pops up when you click the "fx" button.