I am novice in excel just learning,I have created a break tracker where i have to key in time manually.what i want is to click the desired label field and there will a button next to it which will deliver system time on that particular field while i will click on it. And i also want a working button for date as well. 2 seperate button 1 for time and 1 for date. please help.
Hi sap_iias and welcome to the forum!
does this help?
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Thanks a lot brother. the button system its exactly what i want but i want these in multiple field. i will show it to you.
March.xlsx is the tracker i made which the input system i want to make on a button click.
Demo.xlsx is the demo of my idea.
Sorry for the trouble. thanks in advance.
NB: or double clicking on the input field if it captures system time it will do as well.
Last edited by sap_iias; 02-28-2014 at 06:21 PM.
Need help please.
Look at sheet 2 of the attachment to see if this is what you wanted.
Hi again sap_iias!
Take a look at this also:
Every time you click A YELLOW cell in colums "C,D,N,M" the system time will appear on the selected cell.
Have fun!
Thanks everyone. i will check excel after 3 days since i am getting married tomorrow. thanks everyone.
congrats!
check it now, good by spare time after that! lol
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks