VBA Userform Vlookup

Hi,

I'm trying to build a userform in excel which has several inputs. The Product input is a drop down with the selections shown.

If a user selects ProductA and enters a price of $10, the Quantity field should lookup up the ProductA table and return a value of 5 for the Qty. Similarly, if the user select ProductC and enters a price of 50, the Qty should be 2. I want the Quantity field to update once the Product or Price field have been changed. I've attached an example of the workbook and the code I'm working on.

Thanks

Hi anthony_91, here is one way (add this to the Userform1 code):

Please Login or Register  to view this content.

Thanks Berlan. It works, although is there any way of doing this with Vlookups?

I'm afraid i couldn't find a match with vlookup via VBA at my first try, not really sure why (without looking into it in greater detail), but I the alternative I provided should do the trick nevertheless.