Progress bar

[Sarankbm]

Hi Friends,

i was run the macro file but excel sheets going to the busy mode.
so i want progressing bar.what type code can be use kindly Explain.

Regards,
Saran.K

 

[AlanSidman]

Here is a short tutorial

http://www.excel-easy.com/vba/examples/statusbar.html

 

[vletm]

Sarankbm
... and after that Your Macro will be more things to do and
it need to 'rest' short time that You can see change of Your 'progress bar'
... hmm?
Do You use any Application.ScreenUpdating = false there?

 

[Sarankbm]

Thanks but i want status bar
ex: 10% then 50%

 

[vletm]

Sarankbm
It would help a lot for You if You would give code.
So far, could You use something this?
Just add to code that Cell [B4] value would tell Your 'Progress Value'.

 

[Sarankbm]

Hi friend,

Thanks for your response.i have tried to that way but no output.
Please find attached the file. first you will click the button.then file automatically will be go to the busy mode.that time i need status bar progress level.

Thanks.
Saran.K

 

[vletm]

Sarankbm
I didn't find any marks of trying ... hmm?
I did something (and I didn't change Your basic ... idea)
to show that 'Progress' ...
Ps. My File is in different format because ActiveX!

 

[AlanSidman]

I just viewed your file and it shows the progress bar working exactly as required. Is this still an issue for you? Status is in lower left hand corner of worksheet.

 

[Sarankbm]

Thank for your response.
Lot of thanks

Regards,
Saran.K