Im using a Macro at the minute for a piece of coursework for college, all the macro does is transport the user from an input sheet to a hidden output sheet.

My spreadsheet is a quotation system for a paving company, where the user enters personal information and details of what slabs they want, size of area to be paved ect.

The macro then display a quote for them, but heres my problem, when the user presses the submit button i want the macro to check that the user has input into all the required cells, thus displaying a 'stop' message if they have not done so.

Can anyone tell me how to do this please?

Many Thanks

John