Ideas for a userform progress bar.

[HighAndWilder]

Hi All.

I'm developing a userform with a progress ba or something similar..

I'm able to do it if I know how many 'jumps' there will be before the loop starts but does anybody have any ideas in how to construct one
if the number of 'jumps' is not known until the end of the loop.

I just want to let the user know that something is happening.

Thanks

 

[GWteB]

You might be interested in this thread.
While the title of this topic might suggest otherwise, the OP's ultimate goal turned out to be the implementation of a progress bar.

how to set answer = to command button

how do i get this code to wait for a command button click first? Sub ProcessnaTEST() 'Dim answer As NightAuditP.Button1.Caption 'answer = buttonText Call intprogress NightAuditP.Question.Caption = ("Are you ready to start the night audit file process?" & vbNewLine _ & "This is for the date of...

www.mrexcel.com