Building a timeclock
 

When the MsgBox comes up with the present time, I'm trying to get the user,
when they select 'ok', the time would go to a selected cell.

Example:
Monday has cells c7,d7,e7 and f7 for timein, lunch out, lunch in and timeout.

First, can I get the automatic time to go to a specific cell and (2), Is it
possible to reference the date (A8 for Monday)so it is going into the proper
cell?

Alternatively, is it possible to allow only the time stamp (<shift<ctrl<:)?
That, by far, would be the easiest!

Thanks

Building a timeclock
 

What drives the popup of this messagebox? Maybe you could build a form
instead and code behind the form.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Russ" wrote in message
...
When the MsgBox comes up with the present time, I'm trying to get the
user,
when they select 'ok', the time would go to a selected cell.

Example:
Monday has cells c7,d7,e7 and f7 for timein, lunch out, lunch in and
timeout.

First, can I get the automatic time to go to a specific cell and (2), Is
it
possible to reference the date (A8 for Monday)so it is going into the
proper
cell?

Alternatively, is it possible to allow only the time stamp
(<shift<ctrl<:)?
That, by far, would be the easiest!

Thanks