How to insert VBA code into a cell?

[jayantht]

I'm a complete novice to VBA and Excel. I have a piece of VBA.
I got this code from this forum.
This VBA code records the date-time when when another cell has changed.
OK, I get the code pasted into the code editor and saved the file.
The data I change (e.g. manually is in A2) B2 should automatically get updated with the date it changed
How to insert the code into this cell?
Thanks

 

[InfoH]

Can you paste the code so we can see what it's trying to do?

 

[VoG]

You probably need to right click the sheet tab, select View Code and paste in the code.

 

[jayantht]

Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'will put date in a comment when something is put in Column A created by Paul B
If Target.Column = 1 Then
Comment = ("Cell Last Edited: ") & Now & (" by ") & Application.UserName
Target.Cells.NoteText Comment
End If
End Sub

The second one I got from this forum is much simpler:

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Cells(Target.Row, 2) = Now()
End Sub



Yes, I've done the right click on the sheet tab and inserted the code in the sheet that shows up.
How do I activate this code in a particular cell?

 

[VoG]

You enter something in column A.

You can only have one of those codes, not both, or you'll get an error.

 

[jayantht]

You are right, I tried with just one of the pieces of the code not both.
Again, I think my question is very simple, I'm entering a piece of data in cell A1. I want the cell B1 to show the date and time and many the user who changed the data in cell A1.
I believe the first piece of code does that.
the question is what should I put in cell B1, so that it the code is run.

As an example: if I want to multiply contents of A1 and B1 and put the result in C1, I'd type =A1*B1 into C1, similarly what should I put in cell B1 for capturing the change in cell A1.
Thanks

 

[VoG]

The code should run automatically when you enter something in column A. See Events In Excel VBA