Need a formula that checks to see if cells are empty

I have multiple cells that are linked to radio buttons. When a radio button is selected the cell linked to it is populated with a number depending on the radio button from a group that is selected. E.g if the first radio button is selected the linked cell is populated with a 1. I have multiple cells linked to multiple groups of radio buttons. If the user attempts to run a piece of code I have created with any of the linked cells are blank because the user did not select a radio button in one of the groups the system crashes. I need a formula that checks if a range of cells is empty and if so does not run the code but instead displays a message box to inform the user. I have given the cells that are linked to the radio buttons a named range they are called "Buttons".

Attach your spreadsheet so that i can see code to modify it.

Try something like this...

    If Application.Count(Range("Buttons")) <> Range("Buttons").Count Then
        MsgBox "One of the options is not selected. ", vbExclamation, "Missing Selection"
    Else
        'your code here
    End If

Rats. Good job Alpha. I am glad he got you the answer you needed.

Hello mdovey,

Add this line of Code to the Code that runs your big and blue button.

If Application.WorksheetFunction.CountA(Range("Buttons")) = 0 Then 'You may change the count to suit
MsgBox "You MUST make at least one selection in "Order System" before you may continue", vbOKOnly, ("Checking Data Integrity")
End If

Sorry, but I had a long hard day, and cannot sort through all your Code to see exactly where it should go.
So I'm trying a shortcut here!

Hope that helps.

Regards.