Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with implementing onKey
Basically I am making a stopwatch that makes a graph to track time progress. I want to use the onKey function to act as a funciton that will stop the timer, save the time, reset time to 0, then start it again. I have all the methods working, but I cant seem to get the onKey to recognize when I press the key. I want to have the space bar as the key, but it changes the cell's contents everytime (plus i dont know if i can use SPACE as a key). How should I implement it first of all? It only needs to run when the clock is actually running, so I dont think that an event on opening the sheet is needed. Can i do something like this? Do While Not Range("haltClock") Range("clockArea").Value = (time() - clockStart) If Not Range("haltTimer") Then Range("timerArea").Value = (time() - timerStart) End If Application.OnKey "{ENTER}", "boardDone" DoEvents Loop BTW this is what i have, but it doesnt work... -- McManCSU ------------------------------------------------------------------------ McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379 View this thread: http://www.excelforum.com/showthread...hreadid=396249 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with implementing onKey
anyone have an idea -- McManCS ----------------------------------------------------------------------- McManCSU's Profile: http://www.excelforum.com/member.php...fo&userid=2437 View this thread: http://www.excelforum.com/showthread.php?threadid=39624 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
implementing formulas in excel | Excel Worksheet Functions | |||
implementing help for UDF | Excel Discussion (Misc queries) | |||
Problems implementing advanced filter code... | Excel Programming | |||
Implementing an idea ... | Excel Discussion (Misc queries) | |||
Implementing late binding for VBA | Excel Programming |