Hi, I have created the following User Form
I now would like to create a VBA code in such a way that if any of the Text Box is blank a message box would be displayed mentioning that the particular text box cannot be blank, and upon clicking the OK button in the message box it should again return to the same user form.
For Eg. if all 3 text box are blank then message box should say "Please Enter Part Number, Particulars, Vendor Name"
If 2 Text Box are Blank then it would mention the names of the blank text box, same way for one text box being blank.
I would also like spaces to be counted as blank entry in the text box. Only spaces in between 2 words can be allowed in a text box, but that also in 2nd and 3rd text box and not the first one. (First Text Box no spaces are allowed)
I have attached the userform for reference