Help with VBA to look up data from user form and alter or add new if necessary.

Hi there.

On the attached workbook there is a sheet named 'Wet Waste Record' which contains a userform.

Currently the userform looks up the item in combobox1 and adds the value in textbox1 to column b.

I want to if possible allow the userfrom to make a new entry on the spreadsheet if the item does not already exist in the named range WetStockRecord. In the next blank row and paste Combobox1 value in column A and Textbox1 value in column B.

For example on the attached sheet the userform works perfectly on the item d Kronenbourg how ever if I wish to add a record for d Fullers London Pride I cannot at current as programming not correct.


Hope this makes sense and someone can assist.