Hi,

I would like to create a user form with two list boxes. The first list
box will always contain the same set of values from a worksheet,
therefore I can use a With statement in the UserForm_Initialize() sub
procedure. This is the easy part.

However, what I would really like to do is have the list displayed in
the second list box vary depending on the selection made in the first
list box.

Ie
ListBox1 contains "A, B, C, D" etc.
If the user selects "A", then ListBox2 will contain "1, 2, 3, 4".
However, if the user selects "B", then ListBox2 will actually contain
"X, Y, Z".

Is this possible?
Preferably, I would like the information in ListBox2 to appear as soon
as an item is selected in ListBox1.

Thanks, Simon


--
simonhall
------------------------------------------------------------------------
simonhall's Profile: http://www.excelforum.com/member.php...o&userid=30582
View this thread: http://www.excelforum.com/showthread...hreadid=552106