How do I create a time card with excel?
 

I want to create a employee sign in system that creates a time and date stamp
to track working hours over a bi weekly period. I tried excel but can't
figure out how to create a button that when clicked creates the stamp?! Any
ideas my friends?
Thanks,
Basil

How do I create a time card with excel?
 

Not quite sure where you want to go with this, but

View, Toolbars, and ensure Control Toolbox is ticked.

The first icon is 'Enter Edit Mode' click to enter.

Select the Button and click-draw a button on your worksheet.

Rightmouse the button and View Code, amend to:


Code:
--------------------
Private Sub CommandButton1_Click()

If Selection.Value < "" Then
MsgBox "cell already used"
Else
Selection.Value = Now()
End If

End Sub
--------------------


This will timestamp the currently selected cell if it has not
previously been used.

On the Control toolbar, select Exit Edit Mode

--




wackywolves Wrote:
I want to create a employee sign in system that creates a time and date
stamp
to track working hours over a bi weekly period. I tried excel but
can't
figure out how to create a button that when clicked creates the stamp?!
Any
ideas my friends?
Thanks,
Basil


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537386

How do I create a time card with excel?
 

Basil,

they key combinaiton Shift+Ctrl+; will produce the current time.

HTH
Kostis Vezerides