VBA Form Input Range

[mcheng2]

I'm trying to create an interactive VBA form where the user needs to
select multiple ranges. Excel has something built-in that does
this--the small button with a red arrow pointing to the upper left.
When you click it, you're taken to a small toolbar and are allowed to
select ranges. The best example I can think of is creating a Chart
object, it will ask you to select the Data Range.

Is this something I can use in my own VBA form?

 

[Tom Ogilvy]

Userforms have the refedit control for this. It should be available on the
control toolbox toolbar. If not, look at additional controls in tools.

 

[mcheng2]

That was exactly what I was looking for... Thanks!