ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listboxes (https://www.excelbanter.com/excel-programming/294166-listboxes.html)

Lionel Fridjhon

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



All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com