In the "Selectionchange" of a worksheet a form is populated with items from the worksheet. One of the controls is a multiselect listbox that has several classes listed. I want to pre-select the classes that match the details of the worksheet. For example;
Worksheet Class1 through 6 has data 3, 8, 9, 11, 14, 16. The list box has items 1, 2, 3, 5, 8, 9, 11, 12, 13, 14, 16, 18, 23, 24, 32.
When the form is shown I want to be able to see the selected items in the list box where I will either select more or deselect some.
Thanks.
Bookmarks