Message to appear when 5 cells uncolored cells contain values.
Solved/Closed
Fmss8404
Posts
1
Registration date
Monday 12 August 2019
Status
Member
Last seen
12 August 2019
-
12 Aug 2019 à 21:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 13 Aug 2019 à 11:50
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 13 Aug 2019 à 11:50
Related:
- Use the ifs function to return 5 if cell a5 contains the value 3, and return a 6 if it contains any other number.
- Psiphon 3 - Download - VPN
- Thunderbird return receipt - Guide
- What is the function of a hard drive - Guide
- Hitman 3 cheats - Guide
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
13 Aug 2019 à 11:50
13 Aug 2019 à 11:50
Hi Fmss8404,
To do that specific task, give the following code a try:
Best regards,
Trowa
To do that specific task, give the following code a try:
Sub RunMe()
Dim x, y As Integer, mRange As Range
Set mRange = Application.InputBox("Select range", Type:=8)
For Each cell In mRange
If cell.Interior.Pattern = xlNone Then x = x + 1
If cell.Value <> vbNullString Then y = y + 1
Next cell
If x = 5 And y = 5 Then MsgBox ("5")
End Sub
Best regards,
Trowa
