Turn comma seperated list into a range for listbox selections

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.

Please Login or Register  to view this content.

Hi chris01395,

One way ... Check attached file

Please Login or Register  to view this content.