No rush code cleanup help

***Thank you for fixing the code input!!! Now I know***

I have this working just fine, and it is just a project to see if I can make a front end in excel as most people can run excel and not all have Access loaded. It would be a input form that is more user friendly but would put said content in a worksheet for me to upload to a sql server.

I currently have a WKS1("Input") which is user interface and input form / area. WKS2("CSV") is where data is stored once submitted so that it can be easily updated to a database when I wish. WKS 3(Data Sheet") I have my saved variables in named ranges for drop downs in the majority of my input cells.

I include both sets of code, one is a clear value button that I found source code for clearing the data validation selections, and then added the part to clear text values of two other cells (B3,B15). The other is my submit button, which I got done by myself, but I am sure there is some way to greatly reduce the code, or maybe not since I do not use ranges, just non sequential cells. Only way I could have a blank is if they left B3 Name or B15 description blank.

//Reset Button

Please Login or Register  to view this content.

//Submit Button
//First line is something I was trying but could not get it functional so went with the other which I came up with myself.

Please Login or Register  to view this content.

I have put the code tags in for you. To do so you have to put [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.