Data Validation with Dialog Box

[ron.bo]

I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell. After the routine for dialog boxes runs and you go back to the cell for zip codes, data validation works.

How can I make it so that data validation will work when entering data from a dialog box?

Thanks,
Ron

 

[BobUmlas]

Put code to check the zip code in the OK button of the form.

 

[ron.bo]

Thanks for the reply. Sorry, it is an input box not a dialog box... so how do I use data validation with an input box?