LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List and subtotal selected items, then print separate item list TitanG Excel Worksheet Functions 0 September 8th 08 09:07 PM
create new list from list A, but with exclusions from a list B Harold Good Excel Worksheet Functions 3 April 11th 08 11:23 PM
validation list--list depends on the selection of first list Michael New Users to Excel 2 April 27th 06 10:23 PM
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 Ed Excel Worksheet Functions 5 September 12th 05 09:48 AM
find names on list 1 in list 2. list 1 4000 names list 2 400 name Ed Excel Worksheet Functions 1 September 4th 05 12:48 AM


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"