Display inactivity timer in text box on userform

Hello,

This is my first post, I do not have alot of programming experience but I have been able to learn a lot thanks to great forums like ExelForum

I have an inactivity timer which saves and closes the workbook after 25 minutes of inactivity. While they are working in the workbook, there is a userform always on. I would like to have the time remaining until the workbook closes show up in a text box. I am thinking there are a couple ways of doing this but i don't know where to start. Any help would be greatly appreciated!

Here is the code stored in "ThisWorkbook" and "Module1" which has the timer and a couple other things.

ThisWorkbook

Please Login or Register  to view this content.

Module1

Please Login or Register  to view this content.

No race condition - just a missing flag. All my known errors have been fixed. Adjust the time back to 25 minutes and enable the Userform and you should be all set.

Please note that the following syntax is from the 1960s and should be replaced:

Please Login or Register  to view this content.

Lewis

ThisWorkbook

Please Login or Register  to view this content.

Module1

Please Login or Register  to view this content.

Thank you so much for all your help, obviously programming is not my background as you can tell by the ancient syntax.

My pleasure and thanks for the Rep points. Your syntax gave me flashbacks to 'rock and roll'. I never had a chance for the other two.

Lewis