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

[mezza89]

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.

[nathansav]

There's a load of posts similar to this on the forum. Search the forum first, there may be a solution applicable.

[AlphaFrog]

Please Login or Register  to view this content.

[jaslake]

Hi mezza89

Try this for the Command Button Code

Please Login or Register  to view this content.

[mezza89]

Thank you AlphaFrog and jaslake.

Both codes work perfectly thank you.

[jaslake]

Hi mezza89

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.