create a chronometer on excel

[majib]

Hello everybody,

firstly I am sorry for my bad english level. I hope you will understand my problem. I have a chronometer on excel that I would like to modify by adding features. I attach the file.
I would like to time with intermediate times with an alarm when a time (target value) is reached.
For example: I start the timer: click ... click 5 sec. Click .... Click 3 sec. Click .... click. 2 sec
ok 2 sec is my target value, I have an alarm.

Ideally, knowing that it is difficult to have exactly the same value, it would be necessary to integrate a% close to the target value to consider that the target value is reached.

Is it possible?

Thank you all

[Logit]

.
In the mTimer3 module :

Please Login or Register  to view this content.

[majib]

What happens with the module3?

[majib]

sorry I did not see the rest of the message...

[majib]

Hmm, when I insert the code, nothing happens.I am really bad. How do I insert the code into the file?

[leelnich]

This is a bit off-topic, but on my machine, Chrono 1 was "counting" about 36 seconds per actual minute. The following code fixed that:

Please Login or Register  to view this content.

[Logit]

.
Right click FEUIL1

Left click VIEW CODE

Double click mTimer3

Replace Private Sub Chrono() with :

Please Login or Register  to view this content.

[majib]

tks leelnich, my file probably contains a lot of errors

in fact, I think that my basic code is very incomplete to add independant intermediate times with a beep when one of these times is reached
In fact, I want to take the time of every turn of a wheel.
that's why I have to press every time a button to have the passage time
do you think it's possible?

[majib]

Nobody want to help me?

[Logit]

Nobody want to help me?

Post #7 ??

[majib]

Hi Logit,

yes I saw your post but I do not see any differences, probably I'm doing something wrong ....

Im' sorry

[Logit]

.
Open your Module: mTimer3.

Delete everything you have in the module and replace it with this :

Please Login or Register  to view this content.

Then run Chrono 3. At 59:55 you should hear a sound.


The attached has already been changed and works here.

[majib]

YES great thank you logit, I hear the beep
but in fact I wanted the other way 0.1.2.3.4. in the chrono 1. I misspoke in my previous posts
I saw on the code where I can change the time value for the beep


promised after I do not bother you anymore

[Logit]

.

I wanted the other way 0.1.2.3.4. in the chrono 1. I misspoke in my previous posts

Sorry ... I don't understand.

[majib]

ok, the code you gave me is for the timer3 but the timer3 is a countdown
i need the same thing for the timer1 with a beep at 1sec

although my English is not good, I prefer your forum; people are much more friendly and available.

[Logit]

.
Replace the macro code in mTimer with this:

Please Login or Register  to view this content.

[majib]

hummm,

there is not an error in the code?

[Logit]

.
Not here.

[Winon]

@ Logit,

Please don't test my temper!

Your attachment does not download without an error message that there is a problem with the file extension "xls.xlsm".

Maybe just upload it as an xlsm File.

Kind regards.

[majib]

i become crazy with the timer lol

i dont heard the beep

[Logit]

.
WINON !!! Hey brother !

[Logit]

.
Ok .. here it is as an .XLSM format.

[majib]

logit,

tks a lot

it's 10:PM here now i can sleep easy lool

bye

[Logit]

.
Have a good night.

Cheers.

[Winon]

@ Logit,

Hi Buddy,

Thank you for the downloadable attachment. It works well whenever you click on any Button. But when you close any Userform and then close the Workbook, an error message appears " Microsoft Excel has stopped working", and either "Check online for a solution and close the program", or "Close the program". I can't find the problem.

Regards.

[xladept]

@ Winon - Hey buddy, the problem you describe didn't happen on my system

@ Logit - Did it error out for you???

[Logit]

.
No errors here.

Winon .... are you be disingenuous ?

[Winon]

@ xladept,

Thank you for your interest Orrin, I appreciate it.

@ Logit,

Winon .... are you be disingenuous ?

I honestly don't know. Have done a Complete Computer Virus Scan. No problems. Then I did a CHKDSK (Looong procedure), No problems. Then I cleared the Cache and any related issues, but the problem as mention persists!
Could it maybe have something to do with the VBE Properties Settings relating to the Workbook itself?

I am running Office 2010 on Windows 7.

Thanks Guys.

[Logit]

.
Hmmm ........

[Winon]

@ xladept and Logit,

It would appear that I have identified the problem, which seems to do with the Add-In "KuTools" for Excel. The moment I deleted it from Excel the problem has not presented itself again.

Do you guys perhaps know if this is a general issue with "KuTools"?

Logit, your last attachment downloaded without a problem. Thanks.

'Till later then my Friends.

[xladept]

Hi Tjaart,

I have nothing to do with KU Tools but only from ignorance not conviction

Orrin

[Winon]

Thank you Orrin,

That is very well sated!

Have you considered a career in Politics yet?

[xladept]

@ Winon - politics??

I've never molested anyone and have never claimed to.

Besides, almost all of them are my juniors

[Logit]

.
KuTools is a secret weapon of the 'Shadow Government', that has global plans to rule the world.

Deleting it from your computer was the best thing you could do.