| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to add rows to a range using input form | Excel Worksheet Functions | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
| Is it possible to change the Input Range of a Form Control programmatically? | Excel Programming | |||
Linear Mode
