Counting the number of Times a Cell changes colors and Archive

[Closed]
Report
Posts
2
Registration date
Friday April 24, 2015
Status
Member
Last seen
April 28, 2015
-
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
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.


1 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
68
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.