Hi, You can use the Microsoft progress bar component presents in the controls tools box. Set the min and max values in its properties then, during your treatment (vba), modify its value to represent the correct progress of your work.
Personally, I prefer modifying the status bar in my treatment with something like that : Application.StatusBar = "Updating... " & valPercent & "% " & Application.Rept(Chr(1), valPercent \ 10) It sets 0 to 10 special characters in my status bar and a progression in percentage. With this solution, you can have information even if your vba treatment uses Application.ScreenUpdating = False At the end, use Application.StatusBar = False to reset your status bar. Kind regards On 3 nov, 16:19, VILAS CHAVAN <vilaschav...@gmail.com> wrote: > -- > With Best Regards, > --------------------------------------------------------------------------------- > Vilas Chavan > Email : cvi...@ymail.com, vilaschav...@gmail.com > Mumbai - Maharashtra -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
