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
Bookmarks