eddyrcabrera79
Member
Hi,
Attached is the sample Userform I'm working on it. It works perfect. all the information in being transfer to the excel document.
the Help I required is:
Once all the fields in the user form are filled, I press OK and I receive a display message "One record written to Sheet", I press OK and another display message comes up, "Do you want to enter another record?"
1 - After pressing "Yes" how can I make all the fields clear up in the Userform, in order to start inputting new information?
2 - In case one or more fields are empty because no data was input on them, How can I make a display message appear when I press the OK Bottom saying " Please check blank fields"
Please if you can make the corrections in the CODE and let me know by putting a comment what was added or what was included. I just want to see what the solution was to learn
Thanks in advance
Attached is the sample Userform I'm working on it. It works perfect. all the information in being transfer to the excel document.
the Help I required is:
Once all the fields in the user form are filled, I press OK and I receive a display message "One record written to Sheet", I press OK and another display message comes up, "Do you want to enter another record?"
1 - After pressing "Yes" how can I make all the fields clear up in the Userform, in order to start inputting new information?
2 - In case one or more fields are empty because no data was input on them, How can I make a display message appear when I press the OK Bottom saying " Please check blank fields"
Please if you can make the corrections in the CODE and let me know by putting a comment what was added or what was included. I just want to see what the solution was to learn
Thanks in advance