Need a msg box that displays time status or loading status

Hey all,

Is there a way to display a message box, similar to when you do a disk
cleanup, where it gives you the bars as it loads?

Alternatley, can you make it timed so it just takes like 10 seconds to fill
up?

Chip Pearson covers this --- see

http://www.cpearson.com/excel/Progress.htm

--
Cheers
Nigel



"havocdragon" <havocdragon@discussions.microsoft.com> wrote in message
news:5782C641-BE7D-4C59-AE92-A081A500C34A@microsoft.com...
> Hey all,
>
> Is there a way to display a message box, similar to when you do a disk
> cleanup, where it gives you the bars as it loads?
>
> Alternatley, can you make it timed so it just takes like 10 seconds to
fill
> up?

Something to keep in mind: It is not possible to show a progress bar
for a *single* XL/VBA command (open a file, refresh a pivottable,
etc.).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <5782C641-BE7D-4C59-AE92-A081A500C34A@microsoft.com>,
havocdragon@discussions.microsoft.com says...
> Hey all,
>
> Is there a way to display a message box, similar to when you do a disk
> cleanup, where it gives you the bars as it loads?
>
> Alternatley, can you make it timed so it just takes like 10 seconds to fill
> up?
>