I have an example on my website
"Schedule a macro to run"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"arunjoshi " wrote in message
...
i am working on developing a test to be administered to a candidate.

how can control the process by time. when the test-taker clicks the
"start test" button, i can record the "system time" (DateTimeStart) at
that moment. but how do i ensure that at the end of a pre-specified
duration, that is when "system time" becomes = DateTimeStart +
TestDuration, a macro is initiated automatically which will end the
test.

am a novice in macro code writing. would appreciate if you can use a
beginner's language in your respnse. many thanks.


---
Message posted from http://www.ExcelForum.com/