Excel scrollbar linked to a range of values that changes

Posted by pob on March 12, 2001 4:18 AM

I want to have a scrollbar that is linked to a range of values in a column with a min and max. A linked cell with show the current value of the scroll bar which falls between the min and max values of the range. These values are calculated are therefore can change. I cannot use the control scroll bar as this has to have fixed min and max values. Any suggestions?

Posted by David Hawley on March 13, 2001 1:31 AM

pob, use the scroll bar from the "Control Toolbox" with this code:

Private Sub ScrollBar1_Change()
ScrollBar1.Min = Range("A1")
ScrollBar1.Max = Range("A2")
End Sub

Dave

OzGrid Business Applications