Paste values from Textbox in Sheet

[RinorM]

Hi,

I want to paste values from a Textbox into a sheet. I have 15 categories which can be showin in a Userform that appears when running a macro. When someone selects a category I want the values from that Userform to go into the sheet that has the same name as the category chosen in the Userform (I will paste the workbook). In the Pic1 below You can observe which values I want to export to the cells in the sheet. The trick is that each time someone opens this Userform and fills the form and runs it then I want the information to be pasted one row below.

Kunskapscentralen - Logg.xlsm

Pic1.png

Pic2.png

[RinorM]

I have managed to come this far:

Please Login or Register  to view this content.

The only issue I have now is how can I instead of using Sheets("Byggkonstruktion").Activate use the value in a drop-down list that is in the userform?