Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Progress Bar
Hi there, i would very much like to include a progress bar, or use the comman bar status section to display how my macro is doing (so users do no think the process has crashed) I have several modules that are run, starting with Module1. Does anyone have some plug and play code that I can simply copy an paste, and just insert "Call openfobs()" into? thanks in advance, Mat -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=48355 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Progress Bar
The status bar can be written to as follows:
Application.StatusBar = "Please wait..." When done set Application.Statusbar = False to give control back to Excel. But there is no "plug and play" way to show how much progress you have made since the status bar text has no way of knowing what your code is doing, or how close to done it is, without being in some way linked to your code. Normally, what takes code a long time to run is a loop; so you could update the bar in your loop to show progress: For i = 1 to 1000 ' Your loop code Application.StatusBar = "Please wait: " & Format(i/1000,"%##0") & " complete" Next i But how to do this depends on what kind of loops you have in your code and how you would "measure" progress. There is also an ActiveX ProgressBar available in the "Other Controls" of the control toolbox that can be used, but likewise needs to be linked to your code. -- - K Dales "matpj" wrote: Hi there, i would very much like to include a progress bar, or use the command bar status section to display how my macro is doing (so users do not think the process has crashed) I have several modules that are run, starting with Module1. Does anyone have some plug and play code that I can simply copy and paste, and just insert "Call openfobs()" into? thanks in advance, Matt -- matpj ------------------------------------------------------------------------ matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076 View this thread: http://www.excelforum.com/showthread...hreadid=483556 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Progress Bar
Good afternoon Matpj There are quite a few examples available, which provide "slot in" cod to add to your project. Try these out : http://www.cpearson.com/excel/Progress.htm http://www.andypope.info/vba/pmeter.htm HTH Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=48355 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Progress Bar | Excel Programming | |||
Progress bar in VBE | Excel Programming | |||
Progress Bar | Excel Programming | |||
Progress Bar | Excel Programming | |||
Progress Bar | Excel Programming |