Dear Don Guillett / Maries , i saw your previous reply for the subject If I input Letter Y is should show the current date
i guess it is bit similar to that post but i am not able to get this done i tried to use your vba code in to my sheet and instean of "Y" i have changed this to true so that it may change but it is not usefull when i am manualy entering TRUE it is changing but when i click on the chek but it is not changing so i request all you masters please help. Regards, Avinash On Tuesday, February 28, 2012 8:20:11 PM UTC+5:30, Avinash wrote: > > Dear Experts > > i need help in this attached sheet > i want something like this > > if user click on the chek box > > the time stap with the date should come like if user is cheking A then in > column h the status should reflect as what was the date and time when the > user updated that cell and user should not be reupdated that cell once it > is entered then it should be final. > > back dated updation should not be allowed means if the current date is > 28-02-2012 then records should not be available for the updation after the > current date or > > currently if i am cheking A then in column F true value is coming in stead > of true i want date and time to come in this format (m/d/yyyy h:mm AM/PM) > > can anyone please help me to get this done by macro or something in this > regards. > > -- > > Thanks and Regards, > > Avinash Patil > > "Love does not happen its a choice. Its not magic or fate, but it is when > a person takes their natural affinity/attraction for someone and translates > it into commitment and actions that express love." > > > Disclaimer: The information transmitted is intended only for the person(s) > or entity to which it is addressed and may contain confidential and/or > privileged material. If you are not the intended recipient of this message > you are hereby notified that any use, review, retransmission, > dissemination, distribution, reproduction or any action taken in reliance > upon this message is prohibited. If you receive this in error, please > contact the sender > On Tuesday, February 28, 2012 8:20:11 PM UTC+5:30, Avinash wrote: > > Dear Experts > > i need help in this attached sheet > i want something like this > > if user click on the chek box > > the time stap with the date should come like if user is cheking A then in > column h the status should reflect as what was the date and time when the > user updated that cell and user should not be reupdated that cell once it > is entered then it should be final. > > back dated updation should not be allowed means if the current date is > 28-02-2012 then records should not be available for the updation after the > current date or > > currently if i am cheking A then in column F true value is coming in stead > of true i want date and time to come in this format (m/d/yyyy h:mm AM/PM) > > can anyone please help me to get this done by macro or something in this > regards. > > -- > > Thanks and Regards, > > Avinash Patil > > "Love does not happen its a choice. Its not magic or fate, but it is when > a person takes their natural affinity/attraction for someone and translates > it into commitment and actions that express love." > > > Disclaimer: The information transmitted is intended only for the person(s) > or entity to which it is addressed and may contain confidential and/or > privileged material. If you are not the intended recipient of this message > you are hereby notified that any use, review, retransmission, > dissemination, distribution, reproduction or any action taken in reliance > upon this message is prohibited. If you receive this in error, please > contact the sender > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
