Hi
Can anyone help with code that will capture the selected items in a multiselect listbox and store them as variables that can be used in other modules. Best I have come up with so far is to capture the values and send them to a nominated range. I can then refer to those cells and give each variable the value of that cell but I am sure there must be a cleaner way....I just don't know what it is?
Can anyone help with code that will capture the selected items in a multiselect listbox and store them as variables that can be used in other modules. Best I have come up with so far is to capture the values and send them to a nominated range. I can then refer to those cells and give each variable the value of that cell but I am sure there must be a cleaner way....I just don't know what it is?