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 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 28, 2015 at 04:59 PM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 28, 2015 at 04:59 PM
Related:
- Counting the number of Times a Cell changes colors and Archive
- Pinterest archive - Guide
- Sound card colors - Guide
- Count number of occurrences in excel - Guide
- Excel cell color formula - Guide
- Count if cell contains number - Excel Forum
1 response
MaxStart
Posts
338
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Apr 28, 2015 at 04:59 PM
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.
Je ne parle pas français, mais je l'aime.
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.
