Shortz
05-01-2010, 06:48 PM
Heya,
Question on listboxes (again). I have two listboxes in a userform and the second one populates itself based on the first one. the macro to populate the second listbox stores selections from LB1 in an array and searches lists and deletes non selected rows and the remaining cells become the rowsource for the second listbox.
When this runs it causes the selections in LB1 to be unselected. Is there likely to be a simple reason for this? does the array triggers deselection? or do i need to store the selections from LB1 and at the end of the macro recall those selections?
thanks in advance for any help!
Question on listboxes (again). I have two listboxes in a userform and the second one populates itself based on the first one. the macro to populate the second listbox stores selections from LB1 in an array and searches lists and deletes non selected rows and the remaining cells become the rowsource for the second listbox.
When this runs it causes the selections in LB1 to be unselected. Is there likely to be a simple reason for this? does the array triggers deselection? or do i need to store the selections from LB1 and at the end of the macro recall those selections?
thanks in advance for any help!