Scroll bar gives wrong values

StanSz

Board Regular
Joined
Sep 18, 2004
Messages
199
I have a scroll bar that I have set up to have a range of 0 to 1000 with a small move of 1 and a large move of 25.

When I click on the scroll bar I am getting the wrong values. Here's an actual sequence of clicks

Start at 509:

Small Up = 519..... +10
Small Dn = 510..... -9
Small Dn = 502..... -8
Small Dn = 495..... -7
Small Up = 503..... +8
Large Up = 653..... +150
Large Up = 803..... +150
Large Dn = 653..... -150
Large DN = 503..... -150
Small Up = 508..... +5
Small Up = 516..... +8

I've checked and the Small value is set to 1, and the large value is set to 25. At least the large move is consistent at 150 (6 x the set value), but the small move is moving around.

At one time this was working, but I can't imagine what I might have done to alter it.

Anyone have any idea what's causing the wrong values to be given ??

Thanks

StanSz
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,214,641
Messages
6,120,693
Members
448,979
Latest member
DET4492

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top