Find and update table cell

I have a table of data (tblProducts) that has 27 columns of data. Periodically it will be necessary to update the value of a cell in one specific column (col 7).
Rather than having users search the table or bother with a userform, I would like them to be able to locate the cell that requires updating from a small area on the dashboard. I have created a data validation list for the products in the database (column 2 on the database sheet (sheet 2). I also created a VLookup to find the current respective value in column 7. (see image below). The macro I have for the submit button is included below but it results in error 13 Type mismatch. I can't find where the error is. Can anyone help?

Yield.png

Please Login or Register  to view this content.

On which line do you get the error ?

I don't know. It doesn't tell me and doesn't give me the option to go to debug. When I run compile, it shows no error. Is there another way to locate the line?

Thanks. I didn't know that about commenting out the On Error line. Good thing to know. The error occurred at

Please Login or Register  to view this content.

Once I removed that, everything worked great except that I get the same error where I want to clear the values from the dashboard using,

Please Login or Register  to view this content.

How can I accomplish this?

Please Login or Register  to view this content.

Perfect!! Thank you so much for your help.

You're welcome and thanks for the rep.