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

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

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