Vendor form
Posted by Becky on January 07, 2002 7:03 AM
Need help. I am making a form in Excel for my vendors. I have learned how to put a button on the bottom that when hit will send them to a "save as" screen, and I have also learned how to make the form so it has required field entries. The problem I am having is that now when I hit the "save" button it will send warning that not all questions were answered, BUT it will still send them to the "save as" screen. How do I make it so that the form cannot be saved unless all required fields are filled out??
Posted by Damon Ostrander on January 07, 2002 1:06 PM
Hi Becky,
The key here is where you placed the code that checks whether all the fields are filled out. This code must be in a place where it does not run when your userform loses focus to the SaveAs dialog. You should probably have this code in your OK button's click event (if you have such a button), or something comparable that runs when you tell the userform you are done entering values.
Damon
