UserForm Multiple Selection Listbox and Insert Row process Help 2013

[Excelnoub]

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.

[Tinbendr]

See if this will get you started.

You really should learn how to declare your objects. It will payoff in the long run.

THere's no need to deselect the listbox items as you iterate the list. While if this instance, it won't cause any problems, if you ever have a listbox_click event, every time you deselect an item, would cause the click event to be called. Then you're chasing gremlins.

I made the code dynamic on the course list. Meaning, you can add to it and the code will accommodate the extra class.

HTH!

Please Login or Register  to view this content.

[Excelnoub]

This is exactly what I needed to start me with... Tinbendr thank you so much...

Yes I am reading on up some Excel Training Course right now, Learning as I go to become more knowledge full in VBA cause that is where everything is going in my section.

Thank you again.