morsoe
02-28-2014, 01:39 AM
I have several activeX type listbox objects placed in a worksheet (not a userform). One of these has been set as MultiSelect.
The problem is that any change to any sheet on any workbook within the Excel instance has the annoying and inexplicable effect to clear all selections in the multi select listbox.
There are no event codes placed to any of the objects incl worksheet project.
I can probably smoothly work around this by placing the controls in a userform or by reading the selections to an array in VBA before placing using them in my worksheet, however, I would really like to learn how to avoid this.
:hi:Can anyone help?
The problem is that any change to any sheet on any workbook within the Excel instance has the annoying and inexplicable effect to clear all selections in the multi select listbox.
There are no event codes placed to any of the objects incl worksheet project.
I can probably smoothly work around this by placing the controls in a userform or by reading the selections to an array in VBA before placing using them in my worksheet, however, I would really like to learn how to avoid this.
:hi:Can anyone help?