Hello,
I am trying to figure out whether or not it is possible to create a macro that would allow a user to click on a button...
We'll call this button "Start Timing"
at the time that this button is clicked, I want VBA to post that time in a cell in a column Labeled Start.
for example...
If I clicked on "Start Timing" at 10:30 am then the first entry would read 10:30 am respectively.
The other button would read..."Stop timing"
And whatever time it happens to be when I click stop timing should reflect in the next column labeled Finish.
So If I stopped timing at 10:45 am then the spread sheet would look something like this...
Start Finish
10:30a 10:45a
and the next time I click on Start... the time would begin to record in the next row...etc...
Finally in another module...I would like to have it where I can email the results on the spreadsheet.
Any help or guidance would be much appreciated. -Thank You
Bookmarks