How do I create a time card with excel?

W

wackywolves

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
 
B

Bryan Hessey

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
 
V

vezerid

Basil,

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

HTH
Kostis Vezerides
 
Top