Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |