hi.
I have the worksheet named "Time" and in cell "A2" I have the format "hh: mm: ss", I need that when the cell "A2" in the seconds are "00", then it is inserted in a row "A3" and copy the value of "A2" to "A3".
Thank you!
hi.
I have the worksheet named "Time" and in cell "A2" I have the format "hh: mm: ss", I need that when the cell "A2" in the seconds are "00", then it is inserted in a row "A3" and copy the value of "A2" to "A3".
Thank you!
Last edited by marreco; 05-06-2012 at 07:34 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Olá marreco,
The biggest change to the attached workbook was adding the Worksheet_Change event handler. This is triggered when the seconds in cell "A2" equal zero. There were a few minor changes like changing Worksheets("Plan1").Range("A2") to Plan1.Range("A2"). Plan1 the Portuguese code name for the worksheet and not the worksheet's name. I also commented out the call Call aleVBA in the RunTimer procedure because it is not needed anymore. Let me know if I missed anything.
Plan1 Worksheet Change Event
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
was very good, thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks