Newbie needs translation of Andy Pope's code
 

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

--
Smudge

Newbie needs translation of Andy Pope's code
 

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)

"Smudge" wrote in message
...
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

--
Smudge

Newbie needs translation of Andy Pope's code
 

Just "read between the lines". <g

Rick


"Bob Phillips" wrote in message
...
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)

"Smudge" wrote in message
...
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

--
Smudge

Newbie needs translation of Andy Pope's code
 

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


"Bob Phillips" wrote:

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)

"Smudge" wrote in message
...
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

--
Smudge

Newbie needs translation of Andy Pope's code
 

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/...hartLinks.html


Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Smudge" wrote in message
...
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

--
Smudge

Newbie needs translation of Andy Pope's code
 

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 :-)
--
Smudge


"Andy Pope" wrote:

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/...hartLinks.html


Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Smudge" wrote in message
...
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

--
Smudge