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

Tech-Archive recommends: Speed Up your PC by fixing your registry

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: Howto prevent Word doc to be printed in BW, allow it in Color.
    ... Since I create these docs by code, I could easily add this VBA code ... DocumentBeforePrint event, ... The selection in the printer's driver directly (the user might use ... printing if NO visible printer has color caps. ...
    (microsoft.public.vb.winapi)
  • Howto prevent Word doc to be printed in BW, allow it in Color.
    ... Since I create these docs by code, I could easily add this VBA code ... DocumentBeforePrint event, ... The selection in the printer's driver directly (the user might use ... printing if NO visible printer has color caps. ...
    (microsoft.public.vb.winapi)
  • Select from insertion point to text string, and then do it all over again
    ... I am creating 850 static HTML Web pages by using Mail Merge in ... Microsoft Word. ... I have VBA code that allows me to cut a selection from the one, ...
    (microsoft.public.word.vba.general)
  • Re: How do I concatenate fields when Im writing code?
    ... And thirdly, if you are using a SQL string in VBA code, you will need to replace the "s with 's otherwise it will get mistaken for the end of the string. ... Steve Schapel, Microsoft Access MVP ... to filter a combo box selection on the basis of another combo box selection. ...
    (microsoft.public.access.gettingstarted)
  • selecting range for charting
    ... I would like to write VBA code so that an Excel user can select a subset of a large dataset (selection is done by inputting information into a userform) and have the VBA code create a chart using just the subset of data. ...
    (microsoft.public.vb.general.discussion)