VBA Form Input Range
 

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?

VBA Form Input Range
 

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

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
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?

VBA Form Input Range
 

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

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

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
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?