Progress Applet

[Guest]

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.

 

[keepITcool]

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

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Andy wrote :

 

[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)

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.

 

[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

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.