Hi there,
I want to create a stopwatch with the ability to record lap (interval) times in an excel worksheet.
I have tried numerous codes but none seem to work…the one which seems most logical to me is included in the attached document. Basically, when the 'start' button is clicked, I want the current time to be recorded in column F. Ideally, the lap (interval) will also be included in the column next to it (column G).
If anyone can help it would be much appreciated
Cheers,
tb13
End(x1Up) should be End(xlUp)
You are also using a reserved keyword, range in your code.
What you've done looks ok. Your laptim will be current time - the time started.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
cheers.
it is only the reset button that does not work now, and I think its due to the range. What do you mean by a 'reserved keyword'?
a reserved keyword in excel vba is a keyword that has its own meaning in the language... nathansav means you have to change that reserved keyword - name it something else..
don't worry, there's a lot of people that are far more confused than you
but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks