Counting the number of Times a Cell changes colors and Archive

Closed
freygreer Posts 1 Registration date Friday 24 April 2015 Status Member Last seen 28 April 2015 - 28 Apr 2015 à 15:04
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 - 28 Apr 2015 à 16:59
Hello,
Hello, I would like to count the number of times a cell goes green and archive it. How can I do this?
Thank you for any help you can give.


Related:

1 response

MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 69
28 Apr 2015 à 16:59
Changing the cell color on the run DOES NOT raise any event, so u may have to create a custom Class event for that.
Public i As Long


If Cells(1, 1).Interior.Color = 5287936 Then
    i = i + 1
    MsgBox i
End If


Je ne parle pas français, mais je l'aime.