Thread: I don't want to see scroling which VBA does, adding a progress bar
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
marko marko is offline
external usenet poster
  
Posts: 9
Default I don't want to see scroling which VBA does, adding a progress bar
Thanks!!!
So many replys from you guys!!! Thaks to all!!!
Marko

"Edward Ulle" wrote in message
...
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 ***


Reply With QuoteReply With Quote