0

i want to filter data on the basis of value i select from one combo box on another. The image provided is my product master:

Product Master image

where every product has either same or different color. Both product and color column have combo box in my main transaction page. So, when i select any product from product combo box, all the color of that particular product should only be available in color combo box. Transaction of Product Combo box image

Transaction of color combo box

Raymond Wu
  • 3,357
  • 2
  • 7
  • 20
NAITIK JAIN
  • 13
  • 4
  • Please edit your question, include your code attempt to this problem and explain what is not working with your attempt. – Raymond Wu Nov 30 '21 at 04:52
  • 1
    https://stackoverflow.com/questions/70159428/how-to-filter-data-in-combo-box-vba – braX Nov 30 '21 at 04:54
  • 1
    On the `Change` event of your product combobox, construct a filtered array of color based on its value then populate the color combobox `List` with it. – Raymond Wu Nov 30 '21 at 04:55
  • I'm yet to learn the concept of arrays, if you could simplify it for me, will be very much helpful @RaymondWu. – NAITIK JAIN Nov 30 '21 at 05:02
  • @NAITIKJAIN The method in braX's link works as well. Just need to add condition based on the combobox value. – Raymond Wu Nov 30 '21 at 05:07
  • So i need to add condition on change event of product combo box. Will try it. Thank you. – NAITIK JAIN Nov 30 '21 at 05:21

0 Answers0