Hello all,
Been asked to repost here, hopefully someone can help...
Can someone help me perform two tasks on the worksheet i have created and attached,
1, I need to stop the day count once a day has been entered in the progress box (date added in service clearance recieved back cell)
2, Also need to make a function when a Y or Close is entered in the last box the whole row then recieves a strikethrough.
I have never used VBA before...
Can anyone help?
Best Regards
Steve
Last edited by stevieaim; 05-14-2009 at 04:57 PM.
I think you still have some work on the sheet formulas, but click on the Sheet tab and select VIEW CODE, then paste in this Sheet macro:
I'm not sure about the first one, it seemed like you were saying "when I enter a date in column F stop the formula"...but if you TYPE a date over a formula, the formula is gone so the counting stops, right? I thought perhaps you meant column G and make the date in column F permanent at that point...which is what I did above.
Please Login or Register to view this content.
Last edited by JBeaucaire; 05-14-2009 at 05:27 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the inital help the code works for the strikethrough but if i select "No" again i need it to cancel the strikethrough as well.
The reason I need for the days to stop counting in column G is so I can record the number of days overdue column F is showing. This is important for our accounts infomation.
We still need to know when the service clearance for was applied for and when we recieved it back.
Thanks for you help in advance.
Stevie
Does this work better for you? I could spot you asking for any changes in the first part, only the second:
Please Login or Register to view this content.
Last edited by JBeaucaire; 05-18-2009 at 10:36 AM. Reason: Changed J:J code
I have tried the suggested code and it is not working for me, can you suggest anything
Best Regards
Steve
I suggest more information. Post your current workbook with the code installed so I can see what's going on...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks