How to speed up loop code

I have a userform, the main function is to read a list of reference numbers, find the matching record/row on our excel database and mark an offset cell with a temporary value.

It works as it should but I am now trying to speed it up and im thinking the majority would need re-writing. I hae tried implementing the following code to speed things up

Please Login or Register  to view this content.

This didn't help at-all. The speed is the same, but now the excel window disappear randomly while the code runs



Here is the userform code

Please Login or Register  to view this content.

My code might give away I am something of a novice. Regardless this is an app I need to create.
Is it the me.repaint that slows things down? or the method used for looping? (finding the last row then looping 1 to, its the only way i currently understand).

I was using this to show progress. Is there an easy to implement alternative? Ive never liked the progressbar because Ive never managed to make it scale correctly.

update: I have removed the me.repaint to no avail. The code takes just as long. Thanks for the suggestion. Do the loops need doing a different way?

Originally Posted by xladept

Maybe:

Please Login or Register  to view this content.

I got a little too clever for a day, and dismissed your answer! Im very sorry because I tried it today, by setting the textbox's value as a variable and then using that variable in the loop. Thank you

My question is, for my own understanding of excel; Why does that slow the loop? I notice you highlighted the .enabled = false statement, but the value was always read!

Once again thank you, rep+1