Userform connection to excel sheets

[Halos]

Dear All,

I created new userform and added combobox. Opened excel sheet and inserted new sheet and changed name to "Materials". In the combobox properties added row source (Materials!A1:A8). I added also some material names to the "Materials" sheet in the column A. For example, A1=Book, A2=letter, A3=pen and etc...

I need some help - when I run macro and select one of the material name from the list appear in the userform (combobox - dropdownlist), then when I click ok, it should be saved to the sheet1 with inserting new row.

Thanks in advance,

Halid