Good day.
Hope this will make some sense. I have a userform that contains 1 listbox, and 3 textboxes.

I need to have the following function and but all the help or questions found online doesn’t seem to help me at all.

For each selection from my listbox I need to add the information but in a weird way. I will try to add a workbook with an example.

When the user will generate the Userform There will be multiple selection in a listbox. The user will always select almost all of the selections. For each selection made I need to add 2 rows bellow. The initial row will be to have my Column B insert a name as “Total” and the one bellow “English” and the one bellow that “Others”. So if the user select 3 selection from the listbox, 9 rows total will appear and all will have a row with Total, English and Others.

Now the textboxes:

For each textbox needs to be inserted in the same row on all rows, Example If the user adds the same information from stated above, the information from my textbox must add itself to all rows, in this case Textbox1 will be column C, textbox 2, column D… and so on… I need to have place to add more textbox as this is incomplete information and would need help on the basic.

Book1.xlsm

Explanation would be appreciated as I am learning tricks everyday to become more and more VBA efficient Also that I have so much to learn.