Hello, thank you for getting back to me. I have attached the file in question and let me try to reiterate what it is I am trying to do.
The cells that are red, the grey button to the left and the 'Terms and Conditions' check box are all that need work on. I have made a start with the 'customers name' cell where if it is not filled out a message box pops up prompting the user to fill it in. One of the things I need help with is I need the same thing to happen in all cells in red, as they are mandatory fields. Oh and not forgetting the check box.
Without technical know how I tried the follow layout so when the user tries to print the form, if the fields are not complete it will not print and flag up message telling them to fill in the cell.
If Range("J7") = "" Then
If Range("J9") = "" Then
If Range("J11") = "" Then
If Range("H27") = "" Then
If Range("H30") = "" Then
If Range("H33") = "" Then
And also the tick box needs to be tick so not to generate a message box as well.
Once that is done, the button to the left of the form is what I'd like to initiate the code. So when the user presses print, any fields or the check box that are not filled in will flag up an error message.
Then finally, if all fields are completed then the form should print fine.
It is a basic task for someone who knows what they are doing and it will be a brilliant learning curve for me to see the final code. As you have probably been able to tell already, I have no tech jargon which could make it difficult of you to understand what I am wanting. Do ask if you need any info to help understand my requirements. If you are able to help it would be brilliant. Benji.
File download path: