graphs and sliders

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Graphs and sliders

Graphs and sliders

resolvedResolved · High Priority · Version 2003

Christine has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Graphs and sliders

I would like to plot a line graph and have a corresponding slider which, when moved, moved a corresponding point along the line graph.

RE: graphs and sliders

Hi Christine, thanks for your query. You need two things to achieve this. First of all you need to add the slider control into your toolbox. If you right click on the toolbox it will give you the Windows/System folder into which you should save the slider.ocx file (variations of which you can download from the net). Secondly, you need to code a link between the slider control and the point you want to move on your chart. Code-wise this simply involves making sure when the slider is moved to the left, the position of, say, an arrow on your chart moves to the left as well which is done my manipulating the position properties of the arrow. It's quite an involved thing to do but once in place the effect can be quite impressive!

Hope this helps,

Anthony

Mon 25 Jan 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Server loaded in 0.08 secs.