Hi,
I have some data in a Table.
I have defined an Array (without defining the UBounds)as public variable to store the table data.
During the userform initialize event I am using this 2D array to dynamically set its size, store the table data and in turn populate the data in userform listbox.
Later the data in list box can get filtered.
During the userform new data can get added to the table.
Eventually, after some months, my table data may reach 15-20 thousand rows and around 50 columns.
Can this size of table create a problem in the method of using the Array as a public variable and using it for listbox?
rgds
hemant
Bookmarks