Thread: Listboxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lionel Fridjhon Lionel Fridjhon is offline
external usenet poster
 
Posts: 11
Default Listboxes

I have a listbox that has a range of 182 rows as
RowSource, with the control set at MultiSelect.
When I run the code first time, I can get up to 20
selections before running out of memory.
Running the code a second time in the same session, I
find that all my previous selections are still selected,
and even though I select a different set of selections, I
get a message - No not enough memory to do this
operation, and the code stalls at the beginning of the
download of the selection array into a set of variables.

I think my memory problem may be that I am not cleaning
out the old selection.
How can I de-select everything in the listbox?
Is my thinking on this right?

Lionel

Lionel