Locking cells having current time

  • Thread starter Thread starter Junoon
  • Start date Start date
J

Junoon

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?
 
Maybe you meant to post this in an Excel forum rather than an Outlook group?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top