Function not working when used in userform

So to start, I'm super new at this and barely know what I'm doing. I'm trying to make a tracking sheet for logs that I get delivered to my sawmill. Ideally one of my employees can enter in the log characteristics in the userform and it will be transferred to a table to be tallied. I set up some if statements to choose a price based on species and grade. It works as intended when entered into a cell, however I was having trouble figuring out how to select the next row without the row being empty, so I had to remove the if statements and try to put them into the userform. When entered, I get a compile error for end of statement.

Any tips on how to fix this or generally set it up better?

Please Login or Register  to view this content.

Hi, It's difficult to say if this would work without seeing a sample file, but try this slight rework of your code.

Please Login or Register  to view this content.

B.

That worked perfectly, thank you.