Re: I don't want to see scroling which VBA does, adding a progress bar

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks!!!
Now it takes 2 secs not 20 like before!!! I don't need the progress bar now
Thanks!!!

Marko

"Hemanth" <hemanth.singamsetty@xxxxxxxxx> wrote in message
news:1136505432.392657.105320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Set Application.ScreenUpdating == False at beginning of code and
> set it back to True at the end.
>
> I think, excel status bar (at the bottom of the excel workbook) shows a
> progress bar when excel is busy but I'm not sure how to create our own.
>
> - Hemanth
>
> marko wrote:
>> Hi!
>> I made some VBA code which takes about 20 seconds to finish and the
>> selection goes from one row to another and i can see all that. I don't
>> want
>> to see that, I just want VBA to preform my task and I want the screen to
>> be
>> still all the time.
>> And is there a way to add a progress bar so i know when it's finished and
>> how long will it aproximattly take to finish?
>> Thanks!
>>
>> Marko Svaco
>


.

Relevant Pages

  • Re: I dont want to see scroling which VBA does, adding a progress bar
    ... I don't need the progress bar now ... > Hi marko, ... >> I made some VBA code which takes about 20 seconds to finish and the ... >> selection goes from one row to another and i can see all that. ...
    (microsoft.public.excel.programming)
  • Re: I dont want to see scroling which VBA does, adding a progress bar
    ... Marko ... > You probably won't need a progress bar as the execution will be much ... >> I made some VBA code which takes about 20 seconds to finish and the ... >> Marko Svaco ...
    (microsoft.public.excel.misc)
  • Re: Progress Bar Control?
    ... BUT you lose the ability to have a progress bar. ... And writing Excel workbooks like this is slow enough. ... What I want is to display the progress of a routine that uses ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Excel ignoring legitimate code, AGAIN!
    ... Excel is a little thin when it comes to processing 180,000 to 600,000 rows. ... > 600,000+ data points, I included a progress bar so that the user ... > Dim fileHeader As String ... > Dim fileNumber As Integer ...
    (microsoft.public.excel.programming)
  • Re: Excel ignoring legitimate code, AGAIN!
    ... Private Sub ... ' Update progress bar for every five percent completed. ... > needed to be able to recreate the ECG chart in Excel as most of the ...
    (microsoft.public.excel.programming)