Progress Applet

A

Andy

If you have some Excel VBA code which is going to take a little time to run it would be good to display a progress bar to show status of processing - you know, the ones you see during software installations.

Can anyone point me towards some information about this? It would need to be controlled from the VBA because that is where the information is held about the state of the subroutine.

Thanks.
 
B

Bob Phillips

Andy,

Take a look at this one

http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Andy said:
If you have some Excel VBA code which is going to take a little time to
Click to expand...
run it would be good to display a progress bar to show status of
processing - you know, the ones you see during software installations.
Can anyone point me towards some information about this? It would need to
Click to expand...
be controlled from the VBA because that is where the information is held
about the state of the subroutine.
 
R

Rob van Gelder

I have a couple of examples on my website. One for the statusbar area, one
as a command bar control.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


Andy said:
If you have some Excel VBA code which is going to take a little time to
Click to expand...
run it would be good to display a progress bar to show status of
processing - you know, the ones you see during software installations.
Can anyone point me towards some information about this? It would need to
Click to expand...
be controlled from the VBA because that is where the information is held
about the state of the subroutine.
 
Top