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.