Need a progress display while macro is running

[EdgarLopez]

I'm developing a massive macro (low profile software) for a company that performs thousands of calculations and hence runs for a very long time.

I don't want to give the user an epileptic seizure so I turned screen updates off... however, I don't want the user to sit there looking at the screen for ages thinking nothing is going on.

Is it possible to display the progress or the percentage of the code execution on a box while the code is running?

I'm working with Excel type tiles.

Thanks!

 

[SkipVought]

Hi,

Have you considered displaying progress using the StatusBar?

What will progress be based on?

Skip,

_[red][/red]

 

[firefytr]

Hi,

Yes, of course. That would be the Application.Statusbar property. If you're looping, it could go like this ...

Dim i as long, lngTotal as long
lngTotal = 1000
For i = 1 to lngTotal
Application.Statusbar = "Processing " i & " of " & lngTotal
'do code here
Next i
Msgbox "Complete!"
Application.Statusbar = False

You can also do a progress bar. See this Knowledge Base link ...

http://vbaexpress.com/kb/getarticle.php?kb_id=169

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci