Re: Displaying a Progress Indicator (VBA)


Your code should execute almost instantly and therefore a progress bar
is not needed and it wouldn't be able to show progress even if you tried.

To use one requires a value that changes during the execution of the code.
For example that could be in a For/Next loop...

For N = 1 to 100
'do stuff
MyProgressBar.Width = N / 100 * 400
Next
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"shapiro" <shapiro@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message
Does anyone know how to use the Percentage Indicator bar VBA? I found it on
this website http://j-walk.com/ss/excel/tips/tip34.htm and I think it
is really cool. Unfortunately the code is only written specifically for the
purpose of creating random numbers to fill up 25 columns and 100 rows.
Sometimes I come across lengthy macros and wonder if my computer "hung up" on
me.
Look at my simple macro for bold, red and underline
Sub Macro1()
Range("E8:E9").Select
Selection.Font.Bold = True
Selection.Font.ColorIndex = 3
Selection.Font.Italic = True
Selection.Font.Underline = xlUnderlineStyleSingle
Range("I5").Select
End Sub

How do I create a progress bar for this code. I tried but only produced a
"frozen" Progress Indicator bar. I am using windows 2003
Thanks
.

Relevant Pages

  • Re: DELETE statement - Progress
    ... I need to execute a DELETE statement (SQL Server), ... I would like to make a progress bar where I would show a % ... Execute that repeatedly until @@rowcount returns 0. ...
    (microsoft.public.data.ado)
  • Re: function to approximate time elapsed
    ... I need a function to fill a progress bar about how much ... above increment statements should equal kTotalCount (although it's not ... If a particular prock takes longer to execute, say by a factor of 10 ... The finer the resolution, the more "linear" the bar's appearance will be, ...
    (sci.math)
  • Re: Using Thread.sleep(..) and Swing Components
    ... Peter Duniho wrote: ... Operations that take any significant amount of time should be handled on a different thread, using the EventQueue.invokeLaterand EventQueue.invokeAndWaitmethods to execute any code that is required to be executed on the EDT (such as setting the value of a progress bar control). ...
    (comp.lang.java.programmer)
  • RE: fetching data asynchronously using ado.net dataset
    ... DataReader Object and increment your progress bar one step with each record ... before hand so what you need to do it to create two queries for each query ... is the actual query you want to execute, then get its result in a reader ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Progress Bar
    ... Provides a modeless user form showing progress bar, ... Private nVersion As Integer ... Private strStatus As String ... Sub Finish ...
    (microsoft.public.excel.programming)