I'd like to write a macro that will add the current date when a button is clicked.
ex: in sheet1 I have a button that runs a macro when clicked.
on sheet2 which is hidden, when the button is clicked I want the next empty cell in column A to display the current date.
Whenever the button is clicked again, go to next free line and display current date.
Add this line at the end of your current code.
Please Login or Register to view this content.
If row 1 is blank it will still skip that row, but from there on down this ought to do it:
GRRRRR John! You beat me again!!! LOLPlease Login or Register to view this content.
Well done sir!
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thank you both, that did the trick!
You're welcome. Glad to help out and thanks for the feedback.
scabertrain, thanks for the rep and the feedback, and also for marking the thread as closed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks