I ned to create a progressbar with infinity loop...
In effect i need to run the bar from left to to right and right to the left until a process is ended....How to?
pseudo code:
...
run progressbar
call my macro
end progressbar
...
Progress bar VBA for Excel
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Progress bar VBA for Excel
Should the progress bar be placed on a worksheet, or on a userform?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4374
- Joined: 26 Apr 2010, 17:36
Re: Progress bar VBA for Excel
Sorry, in a USERFORMHansV wrote:Should the progress bar be placed on a worksheet, or on a userform?
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Progress bar VBA for Excel
Does the macro contain a loop from which we can update the progress bar?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4374
- Joined: 26 Apr 2010, 17:36
Re: Progress bar VBA for Excel
No loop in code.HansV wrote:Does the macro contain a loop from which we can update the progress bar?
but... start progresbar, call macro, end progressbar
choice you the steep count for the progressbar
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Progress bar VBA for Excel
The attached sample workbook has been adapted from an example by John Walkenbach.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans