Conditional Drop Down?

**heatwave** · 10-25-2010, 11:43 PM

Is it possible to have a conditional drop down where for example, there are 3 categories of products and each category has 3 different items?

Selecting one of the category will restrict a drop down selection to its 3 items only.

More explanation in example.xls attached.

**pr4t3ek** · 10-26-2010, 12:55 AM

this is incomplete..
try it..

Sub Macro1()
    If Range("c3").Value = "Fruits" Then
    doit ("Peaches, test")
    End If
End Sub
Private Sub doit(values As String)
    Range("C3").Select
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=values
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With
End Sub