Problem creating a progress bar

[nicola777]

Hello,

I have some VBA code that searches keywords through a worksheet and deletes the line where the keyword is found. It does this through a loop. Since this is a lengthy process i have created a progress bar. The thing is, the progress bar works, but i have sort of cheated to make it work. In the part:
UserForm1.ProgressBar1.Value = (progress / 350) * 100
I have divided by 350, but i have merely found this number by trial and error. With this number the progress bar stops a 100% so this is just a temporary fix. I was wondering how i can count the number of times the loop runs so i can put the proper number instead of 350.
BTW i found most of this code on the internet.
Any ideas??

Please Login or Register  to view this content.

[Leith Ross]

Hello Nicola777,

Your variable MyStrings gives you that number...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[nicola777]

Hello Nicola777,

Your variable MyStrings gives you that number...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hello
i added a variable total_rows as variant
and before the loop added the code

Please Login or Register  to view this content.

it jumps from 25% to 50% to 75% then 100% then i get an error message invalid property value
what am i doing wrong?