Userform doesn't apply data in correct place! Please HELP!

I took a look at it and tried to figure out why the code wasn't working, but I can't figure it out. It's in the Products tab of the workbook. I need the combobox to send the data to the specific list and the general list. It already sends it to the general list. Had someone help with this on a different workbook, but can't figure it out on this workbook.

If you can help, please explain what I was doing wrong, so I can correct in the future.

The data needs to also go to the column in which the combobox list is specified.

Please help, I will gladly add reputation!

Sorry, I thought I explained it well. The only sheet that matters is products. The macro I'm having trouble with is inventory. In the inventory macro it has two text boxes and a combo box. One function of the user form is that it adds all three values to the general list in column N. That works just fine. The other function is that I would like it to add the data to a specific list (herbicide,disease etc..) based on whatever the combo box value is. If you run the inventory macro it will show you where the error is. In the vba code it's the selcol and selrow code that aren't doing what they should. I tried to figure it out. But can't.

Hope this explains more. Thanks for looking.

Hi Afrabat

I have revisited this as per your request.

Norrie has found and fixed your error for you.