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

Tech-Archive recommends: Fix windows errors by optimizing your registry



Thanks!!!
So many replys from you guys!!! Thaks to all!!!
Marko

"Edward Ulle" <eulle@xxxxxxxxxxx> wrote in message
news:OE5YYPlEGHA.336@xxxxxxxxxxxxxxxxxxxxxxx
> Marko,
>
> Regarding question 1:
>
> Application.ScreenUpdating = False ' turn off updating
>
> Application.ScreenUpdating = True ' turns it back on
>
> Regarding question 2:
>
> See the ProgressBar control. You may have to add it to your controls
> toolbar. "Microsoft ProgressBar Control 6.0".
>
> The progress bar maximum is an integer value so you may have to wrap the
> update function to handle long values.
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***


.