|This code should handle the range B5:M1500 and place the date in Column N of the row that was changed:|
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
If Not Intersect(Target, Range("B4:M1500")) Is Nothing Then
If Target = "Yes" Or Target = "No" Then
Range("N" & Target.Row) = Date
re: "Also is there a list of all the frequently used predefined terms excel uses?"
I'm not sure what you are asking for here. Excel has a long list of built-in functions, but we are not really using "Excel" in this situation. Excel macros are written in VBA - Visual Basic for Applications, specifically VBA for Excel. Each MS Office "product" (Excel, Word, PowerPoint, etc.) has its own version of VBA with its own list of keywords, methods, properties, syntax, etc.
I'm self-taught in VBA for Excel and still rely heavily on Google to figure out how to do a lot of things. There is a huge amount of code available on the web that simply needs to be modified to fit a given circumstance, such as yours. By reverse engineering code that you find in forums, etc. you can learn a lot.
Many years ago I wrote a tutorial that that includes a number of debugging techniques. These techniques are not just good for fixing code that doesn't work, but they are great for reverse engineering code that you find on the web. Once you understand how a piece of code works, you can usually modify it or at least understand how the method/properties/syntax all play together.
That tutorial can be found here:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.