Is it possible to use a form created in vbe to pass a
range to a function. For example, on many Excel default
forms such as the pivot table wizard, a field will accept
a range which is ultimately passed on to a function. How
is that done? I want to use to supply the input range on
a form I define. What control and how do I do this.

Thanks in advance for any help!

Dave