do an *action* when any key or mouse movement is detected

[6diegodiego9]

Is it possible in VBA to detect a system wide key or mouse movement?

I need to trigger an *action* when any key or mouse movement is detected system (Windows) wide

 

[Jaafar Tribak]

Is it possible in VBA to detect a system wide key or mouse movement?

I need to trigger an *action* when any key or mouse movement is detected system (Windows) wide

It is possible using system wide hooks (Do a search for WH_KEYBOARD_LL and WH_MOUSE_LL) but it would be very heavy for your vba to sustain plus you will need rigurous error handling.... You could perhaps run the hook code from a seperate excel instance created on the fly in order to minimize the above issues.

Another possibility is to use a windows timer (SetTimer) and continiously monitor the keyboard state (GetAsyncKeyState, GetKeyboardState ...) and mouse actions (GetAsyncKeyState,GetCursorPos...)

Do a search for all those APIs and you will find some examples.