1. If you tab or arrow thru a cell is the data validation formula run?

2. If the answer to question 1 is no, how can you force the check for a blank cell?

3. Would it be better to validate all the entries in a row with a vba routine run after the last cell is input?

4. Is vba the only way to change the name of the sheet to another name based on input values and then save that filename at the end of each row's entries?

thanks.