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