scroll bar properies in activechart sheet

[Gibbo]

I want to use a scroll bar in an activechart sheet.

Inserting one using Command Bar => Forms => Scroll Bar

Resulting in an "Activechart.shapes(Scroll Bar 1")" which does not allow control of the Max / Min propertiues and I am unable to read the slider value.

Any Ideas??

 

[RoryA]

Try using Activechart.Scrollbars("Scroll Bar 1") instead.

 

[Gibbo]

Hi Rory,

The problem is that a Shape is created and not an object that I can set the required properties

 

[RoryA]

Did you try it?

 

[Gibbo]

The code is not the problem (spelling mistake accepted) it is the fact that I want to be able to set / control the properties of the scroll bar. Under the Command Bar => Forms method it is created as a shape called "Scrol Bar 1" and not a scroll bar object

 

[RoryA]

I repeat: Did you actually try it?
Scrollbars added from the Forms toolbar are members of the Scrollbars collection.

 

[Gibbo]

Spot on ! - thanks

 

[RoryA]

Incidentally, you can also use the ControlFormat property of the shape - e.g.:

Activechart.shapes("Scroll Bar 1").ControlFormat.min = 25

but I find the Scrollbars collection easier.

 

[Gibbo]

Thanks again, youv'e been a greate help