Real Excel VBA Project (Export Data to log sheet, create PDF, Send Email)

In this video I go through a real excel VBA project step by step. I will show you how to log data from a form into a historical spreadsheet in a different document, create a PDF of an audit form, and the generate an automated email which attaches the PDF of the form.

Time Links
[ 00:41 ] Depended Combo Boxes in Form (Data Validation)
[ 02:26 ] VBA Starts (Turn on Developer Tab, ActiveX Button, Design Userform)
[ 05:45 ] Create routines for each option
[ 06:42 ] Data Validation with VBA (Make sure audit form is completely filled out)
[ 08:36 ] Export audit form data to logsheet in separate workbook
[ 16:35 ] Create PDF of audit sheet
[ 20:00 ] Clear audit form information
[ 20:33 ] Send Automated Email with PDF Attachment
[ 25:47 ] Close Form
[ 26:08 ] Wrapping up VBA (Userform defaults, command button execution)

Subscribe: https://bit.ly/2PmVzwJ

- - - - - - - - - - - - - - - - - - -

Previous Video:    • Exploring Excel VBA with Real Project...  

- - - - - - - - - - - - - - - - - - -

Check out my channel for more videos and tutorials for engineers!

Like, follow, share and don't be afraid to drop me a comment/message with feedback, questions, or video suggestions!

Thanks for watching!

Channel Link:    / @theengineeringtoolboxchannel  
Subscribe: https://bit.ly/2PmVzwJ

- - - - - - - - - - - - - - - - - - -

Other great content!

Top Free Engineering Software:
   • EVERY Engineer Should Know About This...  

Excel For Engineers: Other
   • Top 17 Excel Tips, Tricks, & Producti...  

- - - - - - - - - - - - - - - - - - -

Follow and interact!

Subscribe: https://bit.ly/2PmVzwJ
Twitter:   / theengtoolbox  
Facebook:   / theengineeringtoolbox  

- - - - - - - - - - - - - - - - - - -
#ExcelVBA
#Programming
#EngineeringToolbox