I am new to VBA, and I have been trying to figure this one out for over a week. I am trying to create a clock that I can pause the VBA, fast forward, rewind, and play it. I am thinking I will use a userform for the controls of the clock, but the clock will be on the worksheet itself.
I want to enter a start date and time(format: 1/11/09 14:00) into B1 and an end date and time in B2. The clock in A1, would then run through the time sequence by hour, and stop at the end date/time. I would like the speed at which it runs through the clock to be variable, so I can speed it up from .5 seconds/hour to .25 seconds/hour, etc, as well I would like to be able to pause it, and rewind it.
I am using Excel 2003.
Any help would be greatly appreciated!
I want to enter a start date and time(format: 1/11/09 14:00) into B1 and an end date and time in B2. The clock in A1, would then run through the time sequence by hour, and stop at the end date/time. I would like the speed at which it runs through the clock to be variable, so I can speed it up from .5 seconds/hour to .25 seconds/hour, etc, as well I would like to be able to pause it, and rewind it.
I am using Excel 2003.
Any help would be greatly appreciated!