List within a list

[WH99]

Is it possible for the following?
When selecting a item in a combo box list, it drops another list?

 

[Sheeloo]

Yes, in an adjacent cell not in the same cell.

See http://www.contextures.com/xlDataVal02.html

 

[WH99]

Thanks for replying so quick.
Your suggestion is for validation drop down list. Will this work for Combo
Boxes too?

 

[WH99]

Thanks very much I shall try this and let you know how I get on.

 

[Sheeloo]

Yes and no.

Logic would be same...

Here is one example... <http://www.ozgrid.com/forum/showthread.php?t=22822>
'-----------------------
Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
Case "A"
With ComboBox2
.Clear
.AddItem "Alan"
.AddItem "Alex"
.AddItem "Andy"
End With
Case "B"
With ComboBox2
.Clear
.AddItem "Bernard"
.AddItem "Bill"
.AddItem "Bob"
End With
Case "C"
With ComboBox2
.Clear
.AddItem "Charlie"
.AddItem "Chris"
.AddItem "Chuck"
.AddItem "Colin"
End With
End Select
End Sub
Private Sub UserForm_Initialize()

With ComboBox1
.AddItem "A"
.AddItem "B"
.AddItem "C"
End With

End Sub

'-----------------------