Dependent Drop Down

[Kaoutar]

Hi all,

I am working on a form that includes product selection through drop-down menus. It starts off with a product category, a chosen category predefines a choice of product names. After choosing a product name, the user needs to select two parameters which both depend on the product name. My challenge is in having these two lists depend on the unique product name.

Can anyone help me think this through?

Thanks in advance for the help.

Kaoutar

 

[ranman256]

on the afterupdate event of cboCATA, clear and reload items that only have that cata

sub cboCata_afterUpdate()
  LoadProducts
end sub

Sub LoadProducts()
Dim vProd, vCata

cboProd.Clear
Sheets("Products").Select
Range("A2").Select
  'product is in A
  'cata is in B
While ActiveCell.Value <> ""
     vProd = activeCell.Offset(0, 0).Value
     vCata = activeCell.Offset(0, 1).Value
     
     If vCata = cboCata Then cboProd.AddItem vProd         'load product that has the Cata
          
     ActiveCell.Offset(1, 0).Select  'next row
Wend
End Sub