Multiple time stamp

[Vtookup]

Hi All.
Please check this code for time stamp

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("C3:C10")) Is Nothing Then
If Target.Count = 1 Then


Range("B" & Target.Row) = Format(Now, " h:mm AMPM;@")


End If
Application.EnableEvents = True
End Sub

this is a working code. I try to use this code in another worksheet but it won't work.
what should be change in the code if i want to use it in another worksheet (same workbook)
planning to add a few page (Sheets) with time stamp feature.
Hope to get help. Thanks.

 

[alansidman]

It is a worksheet change event that is particular to a certain worksheet. To make it work in another sheet, you will need to copy and paste it into the other worksheet.

 

[Vtookup]

Thanks alansidman for the quick reply.
i did copy the vba into the new sheet and change the cell reference. instead i got "block if without end if". also I noticed that the original sheet that uses this vba is not showing time stamp.
I got this vba online, not well-versed with vba. should I use this vba in more than one sheet (different cell reference), what is the right code?
Thanks.

 

[My Aswer Is This]

Please tell us what your wanting to do.
Finding a script on the internet and showing it to us and saying it does not do what you want does not help us.
Please explain in words what your wanting to do on both sheets if they are different.

 

[alansidman]

The code requires a second line that states End if

Put it after the first one.

 

[Vtookup]

Hi Again, I have 2 worksheet presently, Branch 1 and branch 2. Branch 1 uses the current script (No prob). created Branch 2, the difference between the two sheets are some augmented columns. so cells reference moved.
thought this was merely change cell reference to the script. well i was wrong. so how should the script be written in branch 2 as not to interrupt branch 1's time stamp?
i'm planning to add 3 more in the future. Thanks

 

[My Aswer Is This]

The best way to help you is for you to show us all the code you have in both sheets.

 

[Vtookup]

Hi all
I was impatience with the outcome without really look deep into details. when i rechecked, the range was off and landed on a locked cell. i was clumsy.
now it's working. thanks for all the help.