Counting the number of Times a Cell changes colors and Archive
Closed
freygreer
Posts
2
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
MaxStart Posts 339 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
- Rj45 colors - Guide
- Times attack - Download - Children
- The legend of zelda ocarina of time rom - Download - Action and adventure
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Insert the current date and time in cell a1 ✓ - Excel Forum
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
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.
