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 (lt;shiftgt;lt;ctrlgt;lt;:gt;)?
That, by far, would be the easiest!
Thanks
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)
quot;Russquot; gt; wrote in message
...
gt; When the MsgBox comes up with the present time, I'm trying to get the
user,
gt; when they select 'ok', the time would go to a selected cell.
gt;
gt; Example:
gt; Monday has cells c7,d7,e7 and f7 for timein, lunch out, lunch in and
timeout.
gt;
gt; First, can I get the automatic time to go to a specific cell and (2), Is
it
gt; possible to reference the date (A8 for Monday)so it is going into the
proper
gt; cell?
gt;
gt; Alternatively, is it possible to allow only the time stamp
(lt;shiftgt;lt;ctrlgt;lt;:gt;)?
gt; That, by far, would be the easiest!
gt;
gt; Thanks
- Jun 04 Wed 2008 20:44
Building a timeclock
close
全站熱搜
留言列表
發表留言
留言列表

