Good day guys!
Im newbie on building VBA codes and Im working on a project that is giving me a hard time to successflly complete :S
I have 2 xlsm files, one is called "Management Coaching form" I want my team to fill this sheet ("Form") and whenever they click on "submit" button I want the code to run and:
1. Show a YES/NO Msgbox
2. If on the msgbox the user selects NO then just clear the "form" responses
3. If on the msgbox the user selects YES then run the actions below
4. Register all the "form" asnwers on the xlsm file called "Responses and data collection" on the next blank row putting a DATE/TIMESTAMP on the first column of that next blank row
5. create a PDF of the sheet "form" and then send it automatically thru email using outlook from a noreply email to the emails on the points a) and b) of the "form"
6. save a copy of the PDF generated on my OneDrive
7. clear the form answers
I am attaching both files here, Ive built something but Im pretty sure is wrong bc it is not working how I need it, I hope someone can help me out!
