Message to appear when 5 cells uncolored cells contain values.
Solved/Closed
Fmss8404
Posts
1
Registration date
Monday August 12, 2019
Status
Member
Last seen
August 12, 2019
-
Updated on Aug 12, 2019 at 09:52 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 13, 2019 at 11:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 13, 2019 at 11:50 AM
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.
- Gta 5 download apk pc - Download - Action and adventure
- Hitman 3 cheats - Guide
- If cell contains date then return value ✓ - Excel Forum
- Psiphon 3 download - Download - VPN
- Excel formula to check if cell contains a date - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 13, 2019 at 11:50 AM
Aug 13, 2019 at 11:50 AM
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
