I have a listbox with a thousand rows.
I want to inserting text into specific criteria onto it, by adding some code in celltextpaint event.
The code seems to works, but the problem isI have to scroll it down manually by clicking the scrollbar button.
my question is, how to keep the text there without scrolling manually.
And also I tried to exporting into an excel spreadsheet, the correct result only for the first 15 rows which is shown on the listbox.
I am sure the problem is coming from this celltextpaint which is not refresh automatically.
is there any other ways to handle this method?, I have tried to do it in a button, but does not work.