Userform Timer

Question

Hi all,

I have a userform that has:

1 Label, Named lblTimer and 3 Buttons, Named btnStart, btnStop and btnReset

Label is to display the timer

1 button to start timer, 1 to stop the timer and 1 to reset the timer, at present it works although when i press start it starts at 12:00:00, and counts up not down.

what i would like it to do is as follows:

1. User to set the amount of time to run. in hrs or minutes or seconds. this time would be entered into the Label, then press Start
2. When the time is up it would then play a sound. IE: like a bell ringing or even speech, like say "Ready"

I use excel 2010 and like i said i want this to work in a userform not on a worksheet.

Thanks for any help in advance

Answer 1

Hi Gord,

Yeah i tried using the code from cpearson and can not get it to work the way i need it to.

Thanks for the suggestion though

Regards

Greg

Answer 2

Couple of sites at Chip Pearson's pages to have a look at.

http://www.cpearson.com/excel/OnTime.aspx

http://www.cpearson.com/excel/TimedClose.htm

May get some code ideas you can adapt to suit.

Gord