How to run a process in the background?

  • Thread starter Thread starter yajiv.vijay
  • Start date Start date
Y

yajiv.vijay

I have a macro which will create sheets and update its contents.
I have used
applicaiton.screenupdating=false
to have a background process. I still want to update the user whats
happening behind. Perhaps with a progress bar. Is it possible to have
control on one sheet and have the macro running on the background?
 
I have a macro which will create sheets and update its contents.
I have used
applicaiton.screenupdating=false
to have a background process. I still want to update the user whats
happening behind. Perhaps with a progress bar. Is it possible to have
control on one sheet and have the macro running on the background?
Click to expand...

Yes, you can display a progress bar while the macro is running. It
does however require you to create a form and you will need to add a
bit of extra code.
You may find this link useful

http://j-walk.com/ss/Excel/tips/tip34.htm

HTH
 
Back
Top