I have a list box that pulls a list of people from an
excel spread sheet. These people have people who work for
them. I wish to populate the one list box (listbox1) with
the list of people, then when you click a name, the other
(listbox2) gives a list of the people who work for them.

Can anyone advise.

This is being done in a userform

TIA

Nath.

Devra Dalbleish, er, Debra Dalgleish, has some examples of using Data|validation
with dependent lists at:

http://www.contextures.com/xlDataVal02.html

nath wrote:

I have a list box that pulls a list of people from an
excel spread sheet. These people have people who work for
them. I wish to populate the one list box (listbox1) with
the list of people, then when you click a name, the other
(listbox2) gives a list of the people who work for them.

Can anyone advise.

This is being done in a userform

TIA

Nath.

--

Dave Peterson