Modifying a Macro Button to time stamp when the button was clicked.

**jonvanwyk** · 12-21-2010, 04:02 PM

I have a button that labeled "Employee Signature" that when pressed, uses an image from another part of the worksheet and places it in the signature box (it is a scan of the employee's signature). The code is as follows:

Please Login or Register  to view this content.

Is there a way to add to the VBA for this button so that it automatically time stamps cell AK69 with the date and time that the button was clicked; formatted as: 12/21/10 14:01

Thanks again in advance for any assistance with this!

**dominicb** · 12-21-2010, 04:14 PM

Good evening jonvanwyk

Something like :

Please Login or Register  to view this content.

HTH

DominicB

**jwright650** · 12-21-2010, 04:20 PM

Add this in your button click to stamp the date/time in the cell you want it to hit when the button is clicked

Please Login or Register  to view this content.

see if that gives you what you want.

....whoops....I'm a slow typist...

...see post above

**jonvanwyk** · 12-21-2010, 04:38 PM

dominicb...your solution worked perfectly. I do have one other issue now though. When I click on the "Employee Signature" button, the code below appropriately places the signature, and timestamps the approrpriate cell. If the "Employe Signature" button is clicked again, it also appropriately refreshes the time stamped in AK69. However, it copies an additional signature on top of the old one so that there are now two images on top of each other. The more times you click the button, the more images are stacked. Is there anyway to prevent this? For it to detect that there is already an image there, and prevent stacking? Thanks again!

Please Login or Register  to view this content.

**jwright650** · 12-21-2010, 05:14 PM

When they hit this cmd button, have they entered everything they need to and can close the window at this point?

If so, add a "Close" or "Unload Me" line before the end sub...that way they won't get a second click.

**jonvanwyk** · 12-21-2010, 05:28 PM

I want them to get a second click. If they change something on their timesheet, or have to work unanticipated overtime, they need the ability to click on the signature button again, and have the date/time refresh with the "most recent signature". What I really need is for AF66 to ignore the click if there is already an image in AF66. This way AK69 is still able to update with a refreshed timestamp.

**jwright650** · 12-21-2010, 05:50 PM

Maybe someone with more experience will chime in and set me straight if I'm off base.

[non VBA techy speak on]
I would think you could add a "replace" in there to simply replace the picture with the same picture, or have it look at that cell where the pic is and do nothing to that cell if it see the pic, step over and continue on through updating the other cells where the updated info is important.[/non VBA techy speak off]