Solved: Populate list box from selection in another.

[paulked]

Hi All

I'm using a Worksheet_Change to try to get the 2nd list box to update when the selection is changed in the 1st list box... It doesn't work!

What event should I be looking for to do it automatically?

Many thanks

Paul Ked

[JimmyTheHand]

Rightclick on listbox1, then select Assign Macro from the popup menu.
It will offer the default macro name of "Listbox1_Change".
Select New Macro, then write the code you wish.

HTH

Jimmy

[paulked]

Perfect

Many thanks

Paul Ked