I hate to just jump in with a hard question (at least for me)
I am looking to simply have a userform that will enter data onto a excel sheet.
Drop downs work fine
Prepopulating the date works fine
But when I hit submit (Ok)
I get an runtime error 1004
This is the line that is highlighted...