View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default Autodate and total hours

Fri, 15 Feb 2008 22:26:56 +0000 from jackel <jackel.1fbf994
@officefrustration.com:
When a description is entered into the first cell, I want the date &
time, to automatically insert into a different cell (Protected,Not to
be edited by the user). Then when the project is finished, the date is
entered (pops up automatically) which will display the now date & time.
The total project time only will be displayed in a different cell. I
know how to protect cells.

I do okay with this beautiful program but do not know anything about
Macros or VB. Hopefully, this will be easy for me to do!


Look into events in VBA.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?