showing Labels and Textbox values

Hi all,
adding lables and textboxes in userform automatically by using For loop. I get the vba code by googling it.
Now, my question is I want to show the label caption and textbox values of userform into excel

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Why not use a listbox, 5-6 textboxes for the user to enter data and a command button to add the data to the listbox?

Have a look at UserForm1 in the attached to see the sort of thing I'm suggesting.

Why do you need all those labels and textboxes when you can have the user enter the data in one set of textboxes, then it can be saved to the listbox and easily transferred to a worksheet?

With a listbox the user can update as much or as little data as they want, they can also easily delete/edit data.