Progress bar VBA for Excel

[sal21]

I ned to create a progressbar with infinity loop...
In effect i need to run the bar from left to to right and right to the left until a process is ended....How to?

pseudo code:

...
run progressbar

call my macro

end progressbar

...

[HansV]

Should the progress bar be placed on a worksheet, or on a userform?

[sal21]

Should the progress bar be placed on a worksheet, or on a userform?

Sorry, in a USERFORM

[HansV]

Does the macro contain a loop from which we can update the progress bar?

[sal21]

Does the macro contain a loop from which we can update the progress bar?

No loop in code.

but... start progresbar, call macro, end progressbar

choice you the steep count for the progressbar

[HansV]

The attached sample workbook has been adapted from an example by John Walkenbach.

PROGIND.xlsm