Would someone be so kind to provide a VBA code I can assign to a command
button on a user form that will transfer the data just entered in the form's
fields to a list located on a separate worksheet within the same workbook? I
would like each click of the button to update the list by adding new row and
then to clear the user form preparing it for new data entry. I don't want to
use MS Access for that function.

Thanks a lot!