Code to copy from userform to logsheet not working, no error messages

Hi everyone.

Could someone please take a look at this code and tell me what I need to change to make it function. Background: Userform has info put into fields. After it is complete, user hit submit button which is tied to this:

Please Login or Register  to view this content.

I don't see any errors on this, but it is not copying the data to the logsheet.

Any ideas?


Thanks for your help.

Patrick

I don't see a problem with the code, though I have a few suggestions for cleaning it up a bit (see below). Try putting a debug stop at the beginning and step through it. Make sure it's putting the data where it should and find out what's happening to it.

Please Login or Register  to view this content.

Thanks for cleaning up the code for me Nate. I am still trying to figure out why it is not working. It seemed to quit around the same time I formatted the sheet as a table. Perhaps that has something to do with it.


Patrick

I am not quite sure how this happened, but my data was getting copied to the sheet, just starting at row 1000. I erased the data and tried again and it seems to copy fine. However, I have issues elsewhere. I am now getting a Type Mismatch error that is pointing back to another bit of code I have going. I am at a loss. When I fill out the userform and click the control attached to this:

Please Login or Register  to view this content.

It seems to complete and gets me to the message box. Clicking yes will error out Type Mismatch on this code:

Please Login or Register  to view this content.

Any ideas on what I need to do differently?


Patrick

I have a named range "Infraction" on the Data_Sheet. I have is listed in the rowsource for my userform. The range does match the cells F2:G8.

Brilliant! Thank you so much Norie. Your code did the trick.

Patrick