I have a spreadsheet that is used for checking items out and in. I a
trying to put two buttons on each item row, that can be used t
Date/Time Stamp when the Item is checked out and in.

I want to be able to have each (button) click action enter a Date/Tim
Stamp in the same row in the column directly to the right of th
button. I have tried a variety of methods to avail and I am sure tha
there is a simple method that eludes me. I have little to n
experience with VB.

Essentially, the solution should be generic enough so that the sam
macro can be activated by any button. My thinking is that if the macr
could only take the location of the button (clicked) into account an
then offset the Date/Time Stamp Data by one column this would be th
solution.

At the moment I am working with the following:

Sub Time_Stamp()
ActiveCell.Select
ActiveCell.FormulaR1C1 = Now()
End Sub

What do I need to change to accomplish my objective? Thank you a
advance for any assistance that can be provided.

JP

--
Message posted from http://www.ExcelForum.com