It's much better validating all the values when the user tries to submit the form. It keeps things simple for you and stops your workbook pissing them off if they don't want to fill the form out in the same order that you want them to!