Creating an Excel Stopwatch..

[omairhe]

Hey all,

I would like some help on creating a stopwatch that works every time a key is pressed and stops every time the same key is released.

A pop up that should let the user know for how long the key was pressed for. This should work for any key.

eg format for the pop up window

The key was pressed for 3859 Milliseconds

Thanks.

 

[hiker95]

omairhe,

See if any of the following links will help you.

Create a StopWatch in Excel
http://vbaexpress.com/kb/getarticle.php?kb_id=242
http://www.mrexcel.com/forum/excel-questions/24991-stopwatch-macro.html
http://www.excelforum.com/excel-programming-vba-macros/814242-stopwatch.html]Stopwatch
http://www.vbaexpress.com/kb/getarticle.php?kb_id=242]VBA

 

[Logit]

.
Intriguing question and concept.

Might I ask why you desire to time a key press ?

 

[omairhe]

.
Intriguing question and concept.

Might I ask why you desire to time a key press ?

I'd want to see the speed at which excel would take me from cell A1 to A50 using down arrow while it is in key press state. then, I want to compare the results between two sheets where I suspect is a bit slowing down due to the change event code. But it's more of a fun thing. Thanks for asking though.

 

[omairhe]

omairhe,

See if any of the following links will help you.

Create a StopWatch in Excel
http://vbaexpress.com/kb/getarticle.php?kb_id=242
http://www.mrexcel.com/forum/excel-questions/24991-stopwatch-macro.html
http://www.excelforum.com/excel-programming-vba-macros/814242-stopwatch.html]Stopwatch
http://www.vbaexpress.com/kb/getarticle.php?kb_id=242]VBA

Thanks for the links. Appreciate it.

 

[hiker95]

omairhe,

You are very welcome.

Were you able to find something that you could use?