Mandatory Cells and Return Values

[FaureciaMO]

Have a spreadsheet that I require a clerk to fill out for border customs for each shipment to Canada (last week my clerk sent a truck to customs with NO QUANTITIES on the paperwork...). Basically, they keep forgetting to fill in necessary information. I want to force them to put information in cells H30:H40- and if they fail to enter information, I want the return message to give a value of the specific part number they failed to include a quantity with.

Part Number, Qty
1, 10
2,
3, 20

So in this example I would like the MsgBox to say "You must input Quantities for 2 before Printing"

Hope this makes sense. Thanks for the help folks.

[FaureciaMO]

Here is what I have so far:

Private Sub Workbook_BeforePrint(Cancel As Boolean)

If Cells(30, 8).Value = "" Then
MsgBox "You must input Quatities before Printing"
Cancel = True
End If
If Cells(31, 8).Value = "" Then
MsgBox "You must input Quanties for"
Cancel = True
End If
If Cells(32, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(33, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(34, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(35, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(36, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(37, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(38, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(39, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If
If Cells(40, 8).Value = "" Then
MsgBox "You must input ALL Quantities before Printing"
Cancel = True
End If

End Sub

This works fine; however, I need to return the cell value(s) for the relevant cells in the return message.