Advanced UserForm

I had a similar post answered here a couple of weeks ago, sadly my needs have changed. Providing a link to my first post: http://www.excelforum.com/excel-prog...ml#post2310488


To simplify things I have created 2 sheets, 1 sheet has my data table in it and the other has my inventory data in it. What I am looking to do is to call a UserForm when certain values are entered into a cell and have the ComboBox populated with relevant choices. I am using vlookups to pull some data over from the DATA to the Inventory sheet as well.

If a value entered into my Column A on my Inventory sheet has more that one "Choice" in columns I,J,K, I need the UserForm displayed and only these values to be available in the ComboBox's selections.

If a value entered into my Column A on my Inventory sheet does NOT have more than one "Choice" in columns I,J,K, then I only need the value returned from Column I and do not need to see the UserForm.



I have only added the code below to the "Ok" and "Cancel" buttons on my UserFrom:

Please Login or Register  to view this content.

I have attached my workbook, cheers.