LinkBack URL
About LinkBacks
I have a File that has several rows of costs and incomes. Each row has its own datestamp going day by day.
A testfile is attached.
I want to have a button, that brings me to today's date.
Thanks in advance!
I have a File that has several rows of costs and incomes. Each row has its own datestamp going day by day.
A testfile is attached.
I want to have a button, that brings me to today's date.
Thanks in advance!
Last edited by larsvane; 06-10-2024 at 05:23 AM.
Here, try this:
Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks for your responses. At first I thought both did not work, however that was my own flaw of not incoperating todays date in the list. My apologies.
Both work perfectly. So thank you all!
I will now close the sub.
Last edited by larsvane; 06-10-2024 at 05:22 AM.
Whom are you addressing? Please make this clear. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Both of these worked for me. I'm assuming you erroneously right clicked the button, clicked "Assign Macro" and pasted it. The button itself would still be assigned to the default "Button_Click" macro.
You need to right click the macro button again and "Assign Macro", but this time, choose the macro from the list.
Rather than click a button to add a function, I just want to be able to click into A2 and to run the Macro.
The Macro adds a new line for new data and gives me today's day and date.
This all works, but I need it to go get me the current Day and short form Date (2 separate columns). It just gives me today's day and time. When I use the file tomorrow I need it to give me tomorrow's day and date.
I can send the Macro code if you want?
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #1 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks