Progress Applet
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. |
Progress Applet
see:http://www.cpearson.com/excel/Progress.htm -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Andy wrote : 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. |
Progress Applet
Andy,
Take a look at this one http://www.enhanceddatasystems.com/E...rogressBar.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Andy" wrote in message ... 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. |
Progress Applet
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" wrote in message ... 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. |
All times are GMT +1. The time now is 07:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com