Progress Bar Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I have a spreadsheet that contains a lot of information about client personal, loan & account details

I have created a macro that turns all this information into individual statements for each client in a new worksheet

What I would like to do if possible, is to have a progress bar that shows how much is done and is left to do as the process is being carried out. Currently, a new worksheet openms but, apart from the hour glass, it does not look like anything is happening and may cause another user to try and stop or restart the process

Any help wopuld be greatly appreciated.

By the way, all the work done creating the macro was done with lots of help from people on these Excel communities as I am not a programmer in any shape or form, so with this in mind, please give as much information as you possibly can if the problem can be solved

Many thank

Malcolm
 
See John Walkenbach's page on this for detailed instructions:

http://j-walk.com/ss/excel/tips/tip34.htm
Progress Bar

--
Regards,
Tom Ogilvy


Malcolm said:
Hi

I have a spreadsheet that contains a lot of information about client
Click to expand...
personal, loan & account details.
I have created a macro that turns all this information into individual
Click to expand...
statements for each client in a new worksheet.
What I would like to do if possible, is to have a progress bar that shows
Click to expand...
how much is done and is left to do as the process is being carried out.
Currently, a new worksheet openms but, apart from the hour glass, it does
not look like anything is happening and may cause another user to try and
stop or restart the process.
Any help wopuld be greatly appreciated.

By the way, all the work done creating the macro was done with lots of
Click to expand...
help from people on these Excel communities as I am not a programmer in any
shape or form, so with this in mind, please give as much information as you
possibly can if the problem can be solved.
 
Malcolm,

J-Walk has an example Progress Bar download on his web site.
You can find it here:
http://j-walk.com/ss/excel/files/developer.htm

What you might want to try instead though is to call all your
macros from within a UserForm. The UserForm is modal so
other than a Ctrl + Break, the user has to wait until all the macros
run and they'll have a visual display that something is happening.
(Add a label saying "Please Wait" or whatever you want)

In the UserForm code:

Private Sub UserForm_Activate()
' Call Macro1 here
' Call Macro2 here
' Call Macro3 here
Unload UserForm1
End Sub

John
 
Back
Top