Newbie needs translation of Andy Pope's code

[Guest]

Hi,

Not sure if I am in the right forum, but I would be grateful for any help in
explaining what the code does.

The code
Option Explicit

Private Sub ScrollBar1_Change()

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

This is from the scroll control on a scrolling graph - very neat - but i
would like to understand what it's doing. Hopefully learning as i go along.

Thanking you in advance

 

[Bob Phillips]

Looks like you removed all the code, so how can we tell you what it is
doing?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rick Rothstein \(MVP - VB\)]

Just "read between the lines". <g>

Rick

Looks like you removed all the code, so how can we tell you what it is
doing?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

 

[Guest]

Hi,

I've just copied it by right click - view code

Object is scrollbar 1 and procedure is change.

There is no more code there.

Am I right in thinking that what you are saying is that it doesn't actually
do anything? I think that kind of makes sense. Doesn't make me feel any less
stupid!

Well I did say newbie!

Dare I ask what the few lines of code (that were there) mean or will my face
be even redder?

Cheers--
Smudge

 

[Andy Pope]

Hi,

There is no code required in that example. The scroll bar is simply linked
to a cell.
The cell which it is linked to is then used in a named range.

=OFFSET(Sheet1!$B$1,Sheet1!$E$2,0,Sheet1!$E$3,1)

And the named range is used as the data source in the chart.

For more information on dynamic charts see here
http://peltiertech.com/Excel/Charts/Dynamics.html
http://peltiertech.com/Excel/Charts/DynamicChartLinks.html


Cheers
Andy

 

[Guest]

Thank you Andy.

The scrolling chart is fantastic. Just what I need.

Think I need to do more playing around with offset to understand it better.
Need to walk before running

Thanks again