Creating movable line in excel

[Wildrose]

Hi,

I have to create a movable line which moves parallel to the y-axis. the line would be dragged by a mouse on whichever value i want to see in the chart. The chart consists of 3 graphs. The x-axis acts as the time scale. Each graph in the chart has 15 points plotted with respect to the time. What the movable line has to do is that lets say i want to drag the line to a particular time on the x axis, the values of the 3 graphs in which the line cuts should appear.

I hope you got what i meant. I think for a start, I would like to know how to create "that" line in the chart. Then i can move on to showing the values in which the line cuts the 3 graphs.

Regards,
Wildrose

 

[JohnH]

You haven't posted any VB.Net code. You can use VB.Net with Excel to create/change document, and create Add-ins or COM classes that can be called from the VBA macro language, but you can't use VB.Net directly in macro code. As for what you're actually asking to do I have no idea what you mean.

 

[Wildrose]

Hi,

Sorry for the confusion i have caused. Basically what I am doing is to create a Blood Pressure monitoring system in VB. What my program has to do is to open a txt file and generate the data which is in the txt file. The txt file consists of the blood pressure data. VB has to automatically generate the chart which will consist of 3 graphs by just opening the txt file. So after the chart is generated, the graphs would be shown. What i want to do now is to add a movable line in the chart so that lets say, if i move the line to a certain timing (x-axis acts as a time scale), the 3 points which the line cuts should show values of the blood pressure. I hope you got what i meant.

I am using Visual Basic 2005.

Regards,
Wildrose