Trigger Macro If System Is Idle for Certain Time.

Hi,

I want to know if its possible to auto-run a macro if there was no mouse or keyboard event for say 2mins. I have a code working to record system idle time in total but that gives me endless counts by end of the day as it records every 2 mins.once user logs in to the form.

I instead want to trigger the macro only when user is not using keyborad or mouse for more than 2 mins.

Below code: Paste it in a module, Open the immediate window and run printidletime1. Every 2 mins you would see time stamps in "sheet1".

Please Login or Register  to view this content.

Hi VJOSHI,

Thank you for introducing me to the 'GetLastInputInfo()' API (Application Programmer Interface) routine which retrieves the time of the last the last input event. Please note that whenever the mouse is moved or a key is pressed, the value is RESET to ZERO.

The attached file uses the results from one of your previous questions as a baseline. The Idle time is updated in the UserForm and/or the SpreadSheet. A macro is called when the desired Idle Time expires. Original Question Reference: http://www.excelforum.com/excel-prog...user-form.html

This file is also the solution to a previous unrelated thread: http://www.excelforum.com/excel-prog...idle-time.html

There are two ways to periodically update data (in a UserForm or in SpreadSheet cells:
a. Polling. Polling uses a continuous loop that updates data either unconditionally or according to certain conditions.
The advantages of polling are that it is simple to implement, and relatively easy to debug. The disadvantage of polling is that it hogs computer resources.

b. Event (driven) (aka Interrupt) Processing. Event Processing updates data when an event occurs, such as the press of a button, or the expiration of an [Interrupt] Timer. The advantage of Event processing is that it uses a minimum of computer resources. The disadvantages of Event processing is that it is an order of magnitude more complicated than Polling, and Event processing can be very difficult to debug if something goes wrong.

The solution to your original question uses Polling.

The SpreadSheet Only implementation here is Event Driven. It schedules a macro to run periodically.

Lewis