Form Control Scroll Bar jumping to max value

[Nichole09]

I am having an issue with my form control scroll bar. It works just as intended unless a user is entering data in one of the cells. If a user enters data in cells R77:V94 and does not hit enter before hitting the scroll bar, the scroll bar jumps to the max value. Why is this? I can certainly inform users to hit enter each time they are finished entering data before scrolling, however I would prefer a solution to this problem. Is there a way to add a macro to the scroll bar that will hit enter if the activecell is within this range before it actually scrolls? Thank you!!

 

[6StringJazzer]

I cannot reproduce this. I have set up a Forms scrollbar range 0-5 and when I type into a cell, and immediately click the scrollbar before hitting Enter, it increments by 1.

What is the range of values for your scroll bar? What is the increment? Is the user hitting the middle part of the scrollbar or one of the arrows at the ends?

There is no way for a macro to do what you describe because by the time the macro is called, the scrollbar has already changed its value. But there may be a design change to your overall problem that will solve this for you.