RAKESH230583
New Member
- Joined
- Jan 10, 2011
- Messages
- 46
Hi Friends,
Case : Below table shows some product details, where in under column A we have only 2 product i.e. Product A & Product B.
Column B represent product Group & Last column C represent Grade of (Product and its group).
Excel Sheet 1.
<tbody>
</tbody>
I had created 3 ComboBoxes in Excel userform - But i am not able to get the desired drop down list. As, all three are inter related to each other.
Requirement Example:
Combobox1 : User must see only 2 Product (Product A & B)
Combobox2 : User must see only those Group which are available against that product (i.e Platinum must show only against Product A and not against Product B) - Post selecting product in Combobox1
Combobox3 : User must see only those Grade which are available against that product & Group (i.e. if user select product as "A" and group as "Platinum", then under combobox3 - User must see only 1 Grade i.e. "Grade I")
.
I hope i am clear with above example -
Kindly share your knowledge, for me to understand how to tackle above with vba code.
Thanks in advance.
Case : Below table shows some product details, where in under column A we have only 2 product i.e. Product A & Product B.
Column B represent product Group & Last column C represent Grade of (Product and its group).
Excel Sheet 1.
A | B | C | |
1 | Product | Group | Grade |
2 | Product A | Gold | Grade I |
3 | Product A | Gold | Grade II |
4 | Product A | Silver | Grade I |
5 | Product A | Silver | Grade II |
6 | Product A | Silver | Grade III |
7 | Product A | Platinum | Grade I |
8 | Product B | Gold | Grade I |
9 | Product B | Gold | Grade II |
10 | Product B | Gold | Grade III |
11 | Product B | Gold | Grade IV |
12 | Product B | Silver | Grade I |
<tbody>
</tbody>
I had created 3 ComboBoxes in Excel userform - But i am not able to get the desired drop down list. As, all three are inter related to each other.
Requirement Example:
Combobox1 : User must see only 2 Product (Product A & B)
Combobox2 : User must see only those Group which are available against that product (i.e Platinum must show only against Product A and not against Product B) - Post selecting product in Combobox1
Combobox3 : User must see only those Grade which are available against that product & Group (i.e. if user select product as "A" and group as "Platinum", then under combobox3 - User must see only 1 Grade i.e. "Grade I")
.
I hope i am clear with above example -
Kindly share your knowledge, for me to understand how to tackle above with vba code.
Thanks in advance.