How to set cursor back to textbox on a userform when validating data?

I have a userform that takes userinput into textboxes and stores them into cells of excel sheet. When I am trying to do data validation on the last command button ("save") on the userform. I am not able to set the focus back into the textbox.

Code:

Please Login or Register  to view this content.

The full file is attached for reference. Please check the Add_InventoryBP Userform for the complete code.

Thanks for your help
excelkann

Is there a substitute for Code

Please Login or Register  to view this content.

after setting the focus back to textbox . I would like the program to move further and do the other lines of code and exiting sub here will not make it happen.

Essentially, I would like the program to check for duplicate base product, if yes- place cursor back to base product text box , allow user to correct himself and store corrected value to excel and then move forward to sub product text box and repeat the same process.

place cursor back to base product text box , allow user to correct himself and store corrected value to excel and then move forward to sub product

Once you set focus to the control, you have to exit the procedure to allow the user to make changes then run the Save procedure again. If the changes were successful then that control will not fail the check next time.

If you want to check all controls first then you will have to rewrite, but it's not difficult. You loop through all controls to check, use the CountIf function to determine if the control contents are unique and if not, build a message to display to the user. If, at the end of the control loop the message string contains text then display the message to the user and exit the sub.

It would be a lot simpler to simply exit as soon as a non unique entry was found.