J
Jose
Subject: Re:ST
By: Jose (search by author) In: microsoft.public.excel.worksheet.functions
Many thanks, the code appears to work at least in part. I unfortunately I didn't explain in detailed what I am trying to do
I currently have a worksheet where I list out a series of tasks to be "done" over a course of time. The task list is added to daily and the anticipated due dates recorded. The worksheet gives me networkdays to the due dates. If the task is not marked "done" (in column C) and passes the due date, the task is marked as "over due" and the number of days it is over dued is given. I created the VB module as you provided and saved it the workbook on 1/27/04 for several tasks completed that day, and it did place the date I marked the tasks done, and did not get replaced with the "current date" on subsequent days when I opened the workbook...joy of joys it worked. What I discovered when I entered "done" for several tasks completed today (1/30/04) on the appropriate row in Column C, in Column H where the date appears when I marked the specific tasks as done (in other words, today's date the 30th should have appeared), 1/27/04 appeared. The long and short, I'm trying to capture the date a task is marked done and not have the workbook update the date each time I open the workbook to the "current date" or a "default date". Hope this makes sense
----- Harlan Grove wrote: ----
A few people want to give me 'credit' for a technique that won't work in you
situation. Presumably you could use this workbook several times before C
becomes "Done". The referenced technique would freeze the date you first opene
the workbook after having added the Open event handler, so probably not what yo
want
Would C4 ever change *from* "Done" to anything else? If so, the cell containin
your formula would again become blank? If so, you need a Calculate o
SheetCalculate event handler. Which cells would contain formulas like this
-
To top-post is human, to bottom-post and snip is sublime
By: Jose (search by author) In: microsoft.public.excel.worksheet.functions
Many thanks, the code appears to work at least in part. I unfortunately I didn't explain in detailed what I am trying to do
I currently have a worksheet where I list out a series of tasks to be "done" over a course of time. The task list is added to daily and the anticipated due dates recorded. The worksheet gives me networkdays to the due dates. If the task is not marked "done" (in column C) and passes the due date, the task is marked as "over due" and the number of days it is over dued is given. I created the VB module as you provided and saved it the workbook on 1/27/04 for several tasks completed that day, and it did place the date I marked the tasks done, and did not get replaced with the "current date" on subsequent days when I opened the workbook...joy of joys it worked. What I discovered when I entered "done" for several tasks completed today (1/30/04) on the appropriate row in Column C, in Column H where the date appears when I marked the specific tasks as done (in other words, today's date the 30th should have appeared), 1/27/04 appeared. The long and short, I'm trying to capture the date a task is marked done and not have the workbook update the date each time I open the workbook to the "current date" or a "default date". Hope this makes sense
----- Harlan Grove wrote: ----
A few people want to give me 'credit' for a technique that won't work in you
situation. Presumably you could use this workbook several times before C
becomes "Done". The referenced technique would freeze the date you first opene
the workbook after having added the Open event handler, so probably not what yo
want
Would C4 ever change *from* "Done" to anything else? If so, the cell containin
your formula would again become blank? If so, you need a Calculate o
SheetCalculate event handler. Which cells would contain formulas like this
-
To top-post is human, to bottom-post and snip is sublime