Autodate and total hours
 

Hello,

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!

Thanks for the assistance.




--
jackel

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?

Autodate and total hours
 

Stan Brown;2631509 Wrote:
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?

What description would I look for?




--
jackel

Autodate and total hours
 

Try reading:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jackel" wrote in message
...

Stan Brown;2631509 Wrote:
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?

What description would I look for?




--
jackel

Autodate and total hours
 

jackel

Easy enough to do with event code.

The project starts when user enters a description in a cell and a static time
will be placed into a cell and that cell locked by event code.

I have one question first.

How will Excel know when the project is finished?

Maybe two questions........any particular cells for the times to be entered?


Gord Dibben MS Excel MVP

On Sat, 16 Feb 2008 18:05:09 +0000, jackel
wrote:


Stan Brown;2631509 Wrote:
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?

What description would I look for?