Hi,
I'm trying to find out about the fancy way that Excel allows you to select a range. This functionality appears in a number of places in Excel.
To better understand what I mean, create a chart, then right-click on it and select "Source Data..." (you may have to click around to invoke the correct menu).
You'll see a picture of your chart, with its data range underneath. To the right of that data range is a button that will collapse the form and allow you to select a range. How do you recreate that functionality in a VBA form?
I'm trying to find out about the fancy way that Excel allows you to select a range. This functionality appears in a number of places in Excel.
To better understand what I mean, create a chart, then right-click on it and select "Source Data..." (you may have to click around to invoke the correct menu).
You'll see a picture of your chart, with its data range underneath. To the right of that data range is a button that will collapse the form and allow you to select a range. How do you recreate that functionality in a VBA form?