![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hi,
I am trying to create a TO-DO list, where in column A (TO-DO), i enter the things to do, in Column B (STATUS), i enter the "DONE" or "NOT DONE" (Data Validation drop-down list). If i select "NOT DONE", the corresponding cell in Column C (STATUS TIME) would show the Current Time & the cell would get Locked up & even if change the status to "DONE", the time will not change. In Column D (COMPLETION TIME), i would get the Time when the TO-DO job was completed or DONE. i.e. if i select "DONE" from the Drop-down list in Column C, i should get the Current time in Column D cell. How to do this using VBA? I know that it requires Worksheet_Change event to fire & the Target cells would be the cells in Column C. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
open "new appointment" at current time for incidental meeting etc | Bill! | Outlook - Calandaring | 1 | May 16th 06 12:26 PM |
Enhancement Request: Current time marker should be more prominent | MITREJess | Outlook - Calandaring | 1 | April 25th 06 10:42 PM |
Format current day and time in 5 day view | ChrisO | Outlook - Calandaring | 2 | February 22nd 06 06:08 PM |
Outlook calendar time zone: current time is 1 hour ahead of clock | Natalie | Outlook - Calandaring | 2 | February 12th 06 05:26 AM |
Calendar defaults to current date and time | Milly Staples [MVP - Outlook] | Outlook - Calandaring | 0 | January 7th 06 08:10 PM |