List within a list
 

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

List within a list
 

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

See http://www.contextures.com/xlDataVal02.html
--
If you find this post helpful pl. choose "Yes"...


"WH99" wrote:

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

List within a list
 

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


"Sheeloo" wrote:

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

See http://www.contextures.com/xlDataVal02.html
--
If you find this post helpful pl. choose "Yes"...


"WH99" wrote:

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

List within a list
 

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


"Sheeloo" wrote:

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

'-----------------------
--
If you find this post helpful pl. choose "Yes"...


"WH99" wrote:

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


"Sheeloo" wrote:

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

See http://www.contextures.com/xlDataVal02.html
--
If you find this post helpful pl. choose "Yes"...


"WH99" wrote:

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

List within a list
 

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

'-----------------------
--
If you find this post helpful pl. choose "Yes"...


"WH99" wrote:

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


"Sheeloo" wrote:

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

See http://www.contextures.com/xlDataVal02.html
--
If you find this post helpful pl. choose "Yes"...


"WH99" wrote:

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