Msgbox before macro is run

[Alpacino]

I like to display a msgbox " you must enter figured before running macro" if range C4:O6 is blank and the user tries clicking on rectangle1 which has a macro assigned to it.
Sheet is called "budgets"
Thanks in advance

 

[JoeMo]

Assuming you want to ensure that no cell in the range C4:O6 is blank:

Sub test()
For Each c In Range("C4:O6")
    If IsEmpty(c) Then
        MsgBox "enter figures before running this macro"
    Exit Sub
    End If
Next c
'rest of macro
End Sub

Note that this will not stop the macro from running if all cells in the range have a formula in them which returns "" (null string).

 

[Alpacino]

Nice thank you.
Is there a way to show in msgbox which cell which row is empty for Eg
Row 4 is sales
Row 5 is waste
Row 6 is wages
Msgbox "wages needs completing"

 

[djreiswig]

Sub test()
For Each c In Range("C4:O6")
    If IsEmpty(c) Then
        Select Case c.Row
        Case Is = 4
            MsgBox "sales needs completing"
            c.Select
            Exit Sub
        Case Is = 5
            MsgBox "waste needs completing"
            c.Select
            Exit Sub
        Case Is = 6
            MsgBox "wages needs completing"
            c.Select
            Exit Sub
        End Select
    End If
Next c
'rest of macro
End Sub