I have this code to transfer the selections made in a multi-select listbox into a single text box (TextBoxSupportHelper), then using more code (not shown here) I transfer the Comma seperated list from the TextBox to an Excel table. I am wondering how to do all of the above in reverse? i.e. use comma seperated list from Excel cell to highlight selections in multi-select list box.
As an example the listbox shows following values A, B, C, D, E. The Excel cell with comma seperated list contains A, D, E - so I want A, D and E to be selected/highlighted in the listbox.
I presume I could create a helper table and setup some sort of text to columns and transpose routine, but ideally would like to do this without creating another table.
Bookmarks