Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox to generate 2nd Listbox
I have basic understanding of how UserForms work with listboxes etc, but this is something out of my league. I have my 1st listbox working fine, but what I would like is for the selection from the 1st list box to dictate what list appears in my 2nd listbox. I have a spreadhseet containing hundreds of lists of names. I want to identify the group from the 1st listbox, then choose the relevant person from the 2nd listbox... To finish this off, I want hidden info about that person to populate the main spreadsheet, which I think I can do myself. Any offers on this would be greatly appreciated. Cheers Loiny -- SirLoin ------------------------------------------------------------------------ SirLoin's Profile: http://www.excelforum.com/member.php...o&userid=15933 View this thread: http://www.excelforum.com/showthread...hreadid=536807 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox to generate 2nd Listbox
http://www.xldynamic.com/source/xld.Dropdowns.html
-- Regards, Tom Ogilvy "SirLoin" wrote: I have basic understanding of how UserForms work with listboxes etc, but this is something out of my league. I have my 1st listbox working fine, but what I would like is for the selection from the 1st list box to dictate what list appears in my 2nd listbox. I have a spreadhseet containing hundreds of lists of names. I want to identify the group from the 1st listbox, then choose the relevant person from the 2nd listbox... To finish this off, I want hidden info about that person to populate the main spreadsheet, which I think I can do myself. Any offers on this would be greatly appreciated. Cheers Loiny -- SirLoin ------------------------------------------------------------------------ SirLoin's Profile: http://www.excelforum.com/member.php...o&userid=15933 View this thread: http://www.excelforum.com/showthread...hreadid=536807 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox to generate 2nd Listbox
Good call Tom. Thanks ever so much : -- SirLoi ----------------------------------------------------------------------- SirLoin's Profile: http://www.excelforum.com/member.php...fo&userid=1593 View this thread: http://www.excelforum.com/showthread.php?threadid=53680 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
Modification of listbox to listbox code | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |