Hi everybody. This will be my first post here, I hope to participate and learn as much as I can.
I have a combobox in a userform called ProductSupplierloc which populates products from the 3rd column of DataValidation sheet. I am trying to link a second combobox which will populate the product description of the product chosen in first combo box. Than I need a third combobox which will populate the suppliers that provide this product description.
What I have can be seen by clicking on enter data on data gathering allocation sheet.
The data for the product descriptions are in DataValidation sheet on row 2003 column A. And the data for the Suppliers which offer the product descriptions are on DataValidation sheet on row 4 column Q. I have attached the relevant example.
I had done it via data validation earlier but than my boss wanted the whole thing to be controlled from VBA. I am quite new to VBA and I am trying to learn as fast as I can. I searched in forums found 3 threads but could not implement it. Can someone kindly help me on this issue?
Thanks.
Bookmarks