Active X Scroll Bar max value

[hallingh]

I put in a scroll bar on a dynamic chart yesterday, which I thought was working fine but I realized today still needs some tweaking. The scroll bar is scrolling down values that are referenced from another sheet. The values are part of a named range, which will be added to as time goes on. Currently, I just have the max value of the scroll bar set to the number of entries in the named range. This works fine now, but as values are added will the max value of the scroll bar also have to be changed?

If so, is there a way to automatically set the scroll bar max value to equal the number of entries in the named range? Any help would be greatly appreciated.

Thanks!

Hank

 

[Ruddles]

Without testing it here, possibly something along the lines of:-

[I]scrollbarname[/I].Max = Range("[I]rangename[/I]").Rows.Count