Progress Bar Help
 

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

Progress Bar Help
 

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" wrote in message
...
Hi

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 thanks

Malcolm

Progress Bar Help
 

Malcolm,

J-Walk has an example Progress Bar download on his web site.
You can find it he
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

Malcolm wrote:

Hi

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 thanks

Malcolm