PDA

View Full Version : statusbar indication



lior03
02-06-2006, 10:40 AM
hello
you mark my previous question as solved,it's not.
i am trying to get on the statusbar a progressor like a clock,as to how long it take a macro to completein this case saving a workbook.please help.

Dim Pct As Double
For Pct = 0.1 To 1
Application.StatusBar = "now processing " & Format(Pct, "00.00%")
ActiveWorkbook.Save
Next


thanks

Ken Puls
02-06-2006, 10:44 AM
Hi moshe,

To my knowledge, you can't do this. You can start the statusbar when it starts saving, and once it's finished, but you can't show progress for the actual event itself.

Basically, you could set it to tell you how long it took, but not how much time is left to complete it.

Zack Barresse
02-06-2006, 12:09 PM
Ken is right, this is because "ActiveWorkbook.Save" is one command. You can have a message before that and after that.

Now if you were saving all open workbooks, you could have the status bar display a percent complete (iterative number / total number of workbooks to save).