Check if a range has data in condition to a cell

[agios59]

In a sheet a user enters data in a range, say A1 to F5. In column A the user selects an item from a named list (via Data\Validation\List) with text values. Then, in columns B to F the user enters numbers. In any row he may enters 1,2,3,4,5 numbers or none. When he finishes he clicks a button with name 'Confirm' that saves the data and makes some calculations.
What I want is a macro to run after button click that:
1) If the user selects a value in A and doesn't enter number in any of the cells that are in the same row (I mean if he leaves a row only with data in A, without at least one number in adjacent cells of columns B to F), a stop explaining message to be appeared and prompt him to correct it.
2) If the user enters number or numbers in any cell of the range B1 to F5 and omits to select an item in A, again a stop message to be appeared.

Notice that in all the cells there's Conditional Formatting (font, pattern etc.) with all 3 conditions (Excel 2003).

Thanks in advance...

[StephenR]

Can you post a sample workbook?

[agios59]

Here is the sample workbook

[StephenR]

Work this in at the beginning of your button code:

Please Login or Register  to view this content.

[agios59]

Great! Thank you very much...

[agios59]

I now see that if I fill the empty A cell or the cells with numbers the message is appeared again for the next entire empty row. How I ensure that if a row (columns A to F) is empty I may proceed?

[StephenR]

Slight modification:

Please Login or Register  to view this content.