Thread: Populate dropdown list based on a selection from another (Useful Example)

Here is a useful (Simple) example of a dropdown list based on the selection from another if anyone is interested. The first example uses just the datasheet and the second uses a userform with a dropdown list:

First point of call for info re:data validation would be Contextures:

http://www.contextures.com/xlDataVal01.html

Originally Posted by Mooseman60

I dont seem to be able to open the matchimg combos2.zip file can you give me any advice

Please see the attached file.

For the UserForm removing the need for Dynamic Named Ranges

Code:

Option Explicit

Private Sub ComboBox1_Change()
    Dim iCol As Integer
    If Me.ComboBox1.ListIndex > -1 Then
        iCol = Me.ComboBox1.ListIndex + 2
        With Sheet1
            Me.ComboBox2.List = .Range(.Cells(2, iCol), .Cells(2, iCol).End(xlDown)).Value
        End With
    End If
End Sub