message prompt appears to be delayed

[minato]

Hi,

One of the excel experts Leith gave me a code regarding my time track program. I have a UserForm which contains a Textbox, search, starttime and endtime button. Basically the program works like this: User enters id no from the text box, click on search once id no found, he can click either the starttime or endtime button.The Starttime is working good. However my problem is on the Endtime button. When clicking the endtime button, a message prompt should appear stating the remaining time left for the break. User click "Yes", the time he click the button will be pasted on the worksheet. Code is working however, when clicking the endbutton, the time is being pasted immediately on the worksheet instead of the message prompt which is the first thing to appear. The message prompt should appear first. Once the user click on the "Yes" button, that is the time, the endtime should be pasted on the worksheet.

Here is the code:

Please Login or Register  to view this content.

Thanks,

Minato

[colofnature]

Quick! Change your <code> tags to [code] before anyone else notices!
Also, it might be easier if you were to attach the file. Big screes of text aren't as useful as an example.
Col

[minato]

Hi colofnature,

oopss thanks for the warn. Sorry i dont know how to enclose codes...here is the code again togethjer with the attach sample workbook:

Please Login or Register  to view this content.

Thanks,

Minato

[mudraker]

minato

Your attempt to wrap your VBA code did not work because you used <code>

You should have used square breakets [ ] insted of < >
or use the # key symbol from the text formatting widow

I have fixed up your VBA code wrapping

[minato]

hi mudraker,

thanks for wrapping up my code. I guess i got caught by you as colofnature stated...lols...anyway, do you have any idea regarding my query? Here is an attach workbook

Thanks,

Minato

[Leith Ross]

Hello minato,

I had to basically rewrite most of your code due to the number of errors. The message and times now function correctly. Please see the attached workbook.

Siincerely,
Leith Ross

[minato]

hi Leith,

I can't thank you enough for helping me out with my program. Thank you so much for giving me ideas on how excel vba works. I was able to gather ideas from the revise coding you made. Thank you thank you so much.


Minato