LinkBack URL
About LinkBacks
Hi all,
Is there a way to get the following code to fire once a cell changes in a range of M10:M (if any cell changes from M10 down to "end of project" ?
Thanks everyone!
Please Login or Register to view this content.
Dave
Hi all,
Is there a way to get the following code to fire once a cell changes in a range of M10:M (if any cell changes from M10 down to "end of project" ?
Thanks everyone!Please Login or Register to view this content.
Dave
in thisworkbook code:
in Sheet1 codePlease Login or Register to view this content.
in normal modulePlease Login or Register to view this content.
Please Login or Register to view this content.
Best Regards,
Kaper
Thank you Kaper!
Works just wonderful~ I will call this solved
Right out of the box even
Dave
Hi all,
This worked fine in a sample but now that I am putting it into my actual working schedule I cant get it to work? The only difference is basically I have cells with calculations/formulas in them. Is there a way to make this so it works and skips the cells with formulas in "M and N"
Code is below, and I attached a sheet!
This code when wb_open auto adds today's date in "N" if a date is in "M". When I put a date in "M" it auto puts today's date (F6) into "N". And adds today, each time sheet is opened or changed till 100% complete in "G"
This workbook Code:
Please Login or Register to view this content.
Sheet 1 Code:
Please Login or Register to view this content.
In Normal Module:
Please Login or Register to view this content.
Last edited by davidpierce; 05-22-2015 at 04:04 AM.
Check if these two changes:
andPlease Login or Register to view this content.
helpPlease Login or Register to view this content.
That seamed to work just fine. Thank you again! I will test it tomorrow when the date changes and see if the 100% stops too!
Thanks so much
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks