Send file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Avinash
Sent: Wednesday, February 29, 2012 9:26 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: sheet updation macro
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
--
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
