| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I don't want to see scroling which VBA does, adding a progress bar
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Progress Bar | Excel Discussion (Misc queries) | |||
| I don't want to see scroling which VBA does, adding a progress bar | Excel Discussion (Misc queries) | |||
| VBA - Progress Bar | Excel Programming | |||
| Progress Bar Help | Excel Programming | |||
| Progress Bar Help | Excel Programming | |||
Hybrid Mode
