Excel 2007 : Transfer ListBox Items to Multiple Columns

[loknath]

First of all I would like to Thank the Excel Help Forum for helping me developing my skills in Excel.
With the help of the many experts, I am learning to create an excel file for academic use in my school.
To this end I want the users to select the Class from the ComboBox and then select the corresponding sections from the ListBox. Then the selected sections are to be transferred to respective columns.
I am able to achieve this in One column only but not in other columns. Hope, the forum will help me solve this problem. I have attached the workbook and the vba codes.
Thank you all for your support.

lok Class-Section.xlsm

[royUK]

Try this code

Please Login or Register  to view this content.

[royUK]

Thanks for the rep

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save