I am new to Excel VBA programming and have a User Form pretty much working the way I want it to except for the following problem which I think requires some sort of loop.
My form has 3 different text boxes, Catalog A, Catalog B, and Catalog C. If all three remain without a value when the "Enter Info. " button is pressed to add all information to my database I would like a message box to appear saying "Enter any Catalog No." and no data being entered into the spreadsheet.
Also, if any of the 3 catalogs have had a value entered then I would like all the information entered into the spreadsheet when the "Enter Info." button is pressed.
Any suggestions would be greatly appreciated.

Thanks, Erik