Search for the topic "Time capture of less than one second" in this
group. I gave a Google groups link there, and Pascal also had a
solution.
This will enable you to monitor time in great detail.
To implement, start the code, waiting for the user to CTRL-I, start the
timer upon the first keystroke of "CTRL-I", and wait for x counts (x to
be defined by you). If after x counts, no second event, then reset
timer, and wait again. If second event within x counts, then execute
whatever code.
What I am unsure of is how to capture the keystroke (Don't know what the
code for CTRL-I is). Secondly how to limit the amount of processing
power this code will use, as it will continuously be monitoring stuff
from VBA. But only one way to find out.