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.