VBA code to transfer multiple comboboxes data to different rows of a worksheet

  • Hi All, I would like to know the code to transfer the data of comoboboxes of a userform to different rows of worksheet. The user form that i have created has 5 comboboxes. The first two comboboxes has material description and the second combobox has material name. These two comboboxes values should come in 2nd column and the other in the 3rd column. The 3rd combobox value should come in 3rd column of the 2nd row as the 1st row is a header. Again the 1st combobox value should come in 2nd column and 2nd combobox value should come the other in the 3rd column, the 4th combobox value should come in 3rd column of the 3rd row. Like wise it should add into multiple rows from comboboxes whenever we run the code after populate data in all the 5 comboboxes.