Sorry for not being more specific. My goal is to select the range directly from the chart as opposed to the datapoints. I have written a module that detects the minimum in any range but I want the range to be determined by clicking on or dragging a rectangle on the actual chart. For instance, in the attached graph, I would want to figure out the minimum peak around 1400 wavenumbers by selecting the range around the peak. I have it set up so that a user can type in a range and it will calculate the minimum, but it would be cooler if they could just click on the chart.

Thanks!



Test.png

Sorry, I now see that you actually explained that pretty clearly in your OP. Yes, that would be neat if you could do that! It seems that it may be possible in Office ≥ 2010, which I currently don't have. Check out http://msdn.microsoft.com/en-us/libr.../ff837379.aspx; there are two events that you could use: MouseDown and MouseUp.

Thanks! I'll look into that, but as I also need stuff to work with Office 2007, it may take a few years! For now I'll just have users select a range from an input box like you suggested.