Validation Msg Box Issue

Hi

I have a userform which has validated text box's, when trying to input invalid data a msg box appears.

Issue that i am having is that when i click my update command button and data is exported to my sheet it displays the all of the msg box messages for each text box. I presume that this is caused by the text box's being cleared after they have been copied to my excel sheet but I dont know how to fix it.

This is my Update command code

Please Login or Register  to view this content.

This is the code i use to validate my textboxs

Please Login or Register  to view this content.

Have attached the spreadsheet as well

Please can you help?

http://www.fontstuff.com/ebooks/free/fsUserForms.pdf

take a look at this, i would suggest not using the private sub, but rather have the validation as part of the command button click macro

Thank you so much, all working now and better than what i wanted