RADIO OR SCROLL BUTTON PROGRAMMING QUESTION

[Anon y mous]

I left this question in excel misc a couple of days ago without any nibbles,
so I thought I'd try here (I'm not cross-posting).:

I have a graph- and the spreadsheet performs some calculations for the
graph.

I would like to use two buttons- either radio or scroll- how do I use these
in VB to take, say values in cells M10 and M11 to increase or decrease in
small fractions? One button controls the range of the data and the other
controls the span of the data. If the user does not like the graph range-
they would use the two buttons to either stretch out the span of the graph
or scroll the data up higher or down lower in range. For example, the
first button would control the first data point- ie 10.3 . The second bar
would control how much data would show- ie 10.3-15.5.

I just have to figure out how to code the radio or scroll button to change
the value in cells M10 and M11

Thanks
Paul

 

[BrianB]

<<I just have to figure out how to code the radio or scroll button t
change the value in cells M10 and M11>>

Open the Forms toolbar.
Click on ScrollBar and draw on the sheet.
Right Click on your new scroll ..... Format control.
Set the link and options you want