AltS is used to indicate that the Alt + S keys have been pressed to run a macro that sets AltS to true to allow escape from showing the Msgbox declaring that tolerances have been exceeded. Otherwise I cannot scroll somewhere else because the tolerance msgbox scrolls me back to the field that's out of tolerance. AltS is Dim'd and set to false somewhere else.


I run the SelectionScrollIntoMiddleOfView() macro on Entry of the form fields to center the field when it is selected. At home the macro works. But at work it simply scrolls to the top of the document and stays there, no matter which field is chosen. No error messages are shown.


I think I need to start printing out all the variables in a Msgbox to see the differences between work and home.



Or maybe I need to role back the Office updates to see if it starts working again.


Thanks.

Since the document continues to scroll to the top when I click on a field that runs SelectionScrollIntoMiddleOfView() on Entry, it seems the ActiveWindow.SmallScroll Direction inside the Do Loop is being executed. But the scrolling is not stopping when it is supposed to. So I suspect the conditional statements of the Do Loop are not being evaluated correctly. Let me put some parenthesis in the conditional statement to see if it evaluates correctly. I'll let you know.