VBA Timestamp Help

[tinaluc]

Hi,
I have found a few different VBA codes that shows how to insert a time stamp on a cell once a certain cell has changed, which is a tracking change VBA. The problem with that is, it will only create a time stamp if someone goes in and actually types in a different value, not if it is a formula and the formula causes the value to change. Can anyone suggest another solution? I have the VBA code that I am using below.

A simple example is:
Cell A1 contains a drop-down of A or B
Cell B2: =if(a1="A","apple","ball")
Cell C2 would show the time-stamp of when someone selects a different option in cell A1

---------------

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
'if anything in column B changes
Cells(Target.Row, 3).Value = Now
'inserts the time stamp in column 3
End If

End Sub

 

[JoeMo]

I tried to attatch a picture but it wouldnt let me so I am trying this way instead.
The spreadsheet works is:
F2 is a dropdown of options, low, med, high.
Q7 formula is: =IF(N7="","",IF(AND(N7>$H7,P7>$J7),"WARMER",IF(AND(N7<$G7,P7<$I7),"COLDER","")))

so how it works is: if the user switches from the Low Med High options in cell F2, there can be more colder or warmers in column Q and anytime that changes, I would like a timestamp to show up right next to it.
The data comes in through a spreadsheet that updates throughout the day so I can't use a formula of =now() since I dont want it to update.

Dose that clear it up?


https://plus.google.com/u/0/photos/109835279397223612223/albums/6109037530359574209

I don't see how a change in F2 affects column Q. The formula for Q7 doesn't contain any reference to F2. If I understand correctly, you want a timestamp in column P next to each formula cell in column Q each time a user changes cell F2. Is that correct?

The google link you posted doesn't allow access.