Grant's Error on Submitting His Userform - Data Entry Question

Grant's Userform was giving him a few errors when trying to submit new info to the worksheet. Check out how we helped him!!Here is my link to my workbooks, past present and future.In order to easily and automatically get the latest files, get a free Dropbox account, click here: For access to my workbooks whether or not you're a Dropbox account user, use this: Playlists:Excel Vba Basics Tips N Tricks Userforms Sample Excel Programs Events Series Activex Controls Grab a T-Shirt or Hoodie: Interact and Follow me on:LinkedIn: Facebook: Twitter: Google Plus+: google.com/+ExcelVbaIsFun'Royalty Free Music by