Excel listbox

[Gary]

Hi,

Can someone please help me out here. Is it possible to have a listbox
populated with a few entries and then have a 2nd listbox populated
based upon which items are selected in the first listbox? For example:

ListBox1 =

Item1
Item2
Item3

ListBox2 =

If Item1 is selected then show xxx
If Item2 is selected then show xxx
If item3 is selected then show xxx

Any ideas?

Thanks.

 

[John Bundy]

This is called cascading listboxes, there are many examples depending on the
format of your data such as:
http://www.mrexcel.com/forum/showthread.php?t=406562
or
http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

 

[gdf1903]

This is called cascading listboxes, there are many examples depending on the
format of your data such as:http://www.mrexcel.com/forum/showthread.php?t=406562
orhttp://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
--
-Johnhttp://www.jmbundy.blogspot.com/
Please rate when your question is answered to help us and others know what
is helpful.










- Show quoted text -

Thanks a lot. That's exactly what I need. Much appreciated.