time stamp

Here is what I am looking to do and I have wasted to much time trying to do it myself.

A1 - a changing number, each time it changes I want B to time stamp down the column.

EX. User states
A1 = 1 B1 = MM:DD:YY HH:MM:SS
A1 = 3 B2 = MM:DD:YY HH:MM:SS
A1 = 7 B3 = MM:DD:YY HH:MM:SS
A1 = 19 B4 = MM:DD:YY HH:MM:SS


PLEASE HELP POST HASTE BEFORE I LOSE MY MIND!

I must be doing something wrong. I went to Developer, Visual Basic, General, Worksheet Change and pasted

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
SetDateRow Target, "B"
'or
'SetDateCol Target, 2
End Sub

Sub SetDateRow(Target As Range, Col As String)
If Target.Cells.Count > 1 Then Exit Sub
Application.EnableEvents = False
Cells(Target.Row, Col) = Int(Now())
Application.EnableEvents = True








It's not working.

@Newdoverman

My Mistake - I rushed to copy the code and missed the End Sub, thanks for correcting it.

For whatever reason when I attempt to open the specific worksheet VBA, a grey blank screen pops up, it's unlike the normal white screen where you can chose your project and paste the information. I have no clue what is wrong with this thing.

So I feel like we are very close to what I was looking for. In your attached excel sheet, "Time date Stamp", the way you have designed this was that the user would have to input data in cells A2 thru A10. I was looking for a single point of data entry on another sheet, in the attached scenario, on sheet 1 the user would input the data into block I2, ( I have a macro that accumulates the time on J2 and clears I2 after input) but I want it to time stamp on Sheet 2 each time information is input into I2. This may be to much, but this is really what I was hoping to achieve. So on sheet 2, each time information is entered onto Sheet 1 I2, a time stamp would appear on sheet 2 A1, A2, A3, A4, A5, A6 etc. Does this make sense and is this obtainable? Please keep in mind that multiple users use this sheet and there will be multiple points of data entry, Ex, I2, I3, I4, I5, etc. Approx 50. time-stamp-time-date-stamp.xlsm

time-stamp-time-date-stampR1.xlsmThe more I think about it, Is it possible that each time a number is entered onto sheet 1 I2, a copy of that information is carried over to Sheet 2 with a time stamp even though I2 is designed to erase after input. attached is a created scenario that I made up implying that 3 inputs were made each of user input 2 for a total of 6. Let me know if this is doable because this would capture the data best I believe. Thanks for looking!

Hi Dave,

I tested your code but I get an 'ambiguous name change' error when I edited the set sheet name to my second sheet name of "Tab Stamp" .

Also, does this code get placed in 'Workbook, Sheet 1, Sheet 2 or a module' ?

So this is amazing and works perfect. Now to add another pickle to the puzzle. Can we add a user ID to the time stamp. As an example, 10 people have access to this shared work book. Although each line item is tasked to a specific person, I'm curious If it can not who input the data in block C.

Also, how do I change the code to add all of the other lines, ex, I4, I6, I8, I10...