List Box Value to drive other Values.

**DSL1970** · 12-28-2012, 11:24 AM

I have created a list box with 5 values in it... My goal is depending on which of these values is selected I want another list box that only presents specific corresponding values to what was selected. For example, in the first list box I have values A,B,C,D and E; A corresponds to 1,2 or 3, B corresponds to 4,5 or 6 and so on. I want to select "A" in the first list box, and then only be presented with the options of 1,2 or 3 in the second list box; Or, select "B" and only be given the choices of 4, 5 or 6... and so on.

Any help will be appreciated.

Regards,

DSL1970

**Norie** · 12-28-2012, 11:33 AM

Try this.

Private Sub ListBox1_Change()
      Select Case ListBox1.Value
           Case "A"
                ListBox2.List = Array(1,2,3)
           Case "B"
                ListBox2.List = Array(4,5,6)
           Case "C"
                ListBox2.List = Array(7,8,9)
           Case "D"
                ListBox2.List = Array(10,11,12)
           Case "E"
                ListBox2.List = Array(13,14,15)  
       End Select
End Sub

**DSL1970** · 12-28-2012, 02:10 PM

I think I may have incorrectly called my entry in List Boxes.... I am using the Data Validation Tool (List Criteria) and populating the first 1,000 Rows in a specific column.

Column L
Entry options A, B, C, D, E

Column M
List Options for A = 1, 2 or 3
List Options for B = 4, 5 or 6.....