View Single Post
 
Old 02-07-2020, 08:04 PM
MikeatMSOffice MikeatMSOffice is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2020
Posts: 3
MikeatMSOffice is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
Are you saying the document event is not firing or the code is producing an error?

If it is an error, what line is failing and what error message are you seeing?
What is AltS used for and why is it undefined?

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.

Last edited by MikeatMSOffice; 02-08-2020 at 08:59 AM.
Reply With Quote