Counting the number of Times a Cell changes colors and Archive

Closed
freygreer Posts 1 Registration date Friday April 24, 2015 Status Member Last seen April 28, 2015 - Apr 28, 2015 at 03:04 PM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 28, 2015 at 04:59 PM
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 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 28, 2015 at 04:59 PM
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.
0