Slow vba cell update with listbox.

[Stingone]

Hi everyone.

I'm working on a script for a while know. Everything works fine except that the updating goes very slow.
I use the code below. I have a excel sheet with a range from A8:H282. When i use the update button it takes about 2 second before the new value has been listed and updated.

The other thing is that when the listbox has been loaded the scrollbox is very very long. So it displays the range but i can scroll a lot of white space after the listed range.

Please Login or Register  to view this content.

Update button

Please Login or Register  to view this content.

[Norie]

Does this speed things up any when populating the listbox?

Please Login or Register  to view this content.

It's not clear, to me anyway, what exactly you are updating but it only looks like it's a few cells so I don't know why it's taking 2 seconds.

[Stingone]

Does this speed things up any when populating the listbox?

Please Login or Register  to view this content.

It's not clear, to me anyway, what exactly you are updating but it only looks like it's a few cells so I don't know why it's taking 2 seconds.

No effect, i think it had to do with the update box. I only update one row with a length of 5 columns a time.

[Norie]

I ran your code and it did take quite a bit for the listbox to be populated.

With the code I posted there was no wait at all, it happened straight away.

The code I posted isn't anything to do with updating, it's for the initial population of the listbox.

Perhaps you could upload a sample workbook.

[Stingone]

I ran your code and it did take quite a bit for the listbox to be populated.

With the code I posted there was no wait at all, it happened straight away.

The code I posted isn't anything to do with updating, it's for the initial population of the listbox.

Perhaps you could upload a sample workbook.

Thanks for the reply. I will upload the sheet after my sleep maybe it has to do with the fact that my cells have cell property's. Eg % etc. That's why I used my code. But I will post.my sheet ASAP.

[Norie]

The reason for your code being slow is probably just because of the loop which is going through 2000+ cells.

Unfortunately it looks like you might need the loop if you want to keep the formatting.