Way to select a range using the mouse on a chart?

omahadivision · #1 12-20-2012, 08:10 AM

Hi all,

I have written a module that determines the row of a address of a range of a series on my scatter plot chart. It works great except for one thing - I need to enter the custom range in VBA or by selecting the cells. I was wondering if there was a way to draw a rectangle or something similar on the chart and then have the range on the X axis covered in the rectangle become the range in the macro. There is only one series on my chart. Basically, it's a wavelength spectrum where the peaks vary, and I'm looking for ways to select individual peaks.

Here's the code as is with the range manually entered, with minpoint1 being the address of the minimum:

Code:

Dim minpoint1 As Integer

minpoint1 = MinAddress(Range("B53:B150"))

And the function MinAddress:

Code:

Function MinAddress(ByRef ThisRange As Range) As String
    Dim cel As Range
    For Each cel In ThisRange
        If cel = Application.WorksheetFunction.Min(ThisRange) Then MinAddress = cel.Row
    Next cel
End Function

Thanks!

-Dave

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Making VBA select chart and then export as picture	omahadivision	Excel Programming	2	10-28-2012 07:53 PM
Mouse Over Animation	dslocum	PowerPoint	4	03-23-2012 09:20 AM
Can't select or edit chart data	itguy	PowerPoint	2	09-19-2010 10:13 AM
Converting manual chart to bar chart?	aligahk06	Excel	0	07-03-2010 12:23 PM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM