 | ||||||
Progress bar
Can Do
![Goto Guest book sign in page [Home]](files/guestbook.gif)
Thanks for visiting my site lucky visitor:
This page was last updated on: March 16, 2008
Copyright © 2002. XcelFiles. All Rights Reserved Ivan F Moala
Progress bars are useful for displaying the progress of an operation. Microsoft Excel provides a progress bar control. Whilst this is useful, there are times when you need to display it where an ActiveX control cannot be shown eg the Status bar area of the Microsoft Excel application. John Walkenbach has a routine here to do this thanks to David Wiseman, BUT placing this in some other area may take a bit of work. Here is a routine that takes advantage of the comctl32.dll and it's controls that you can access if you know it's class name and how to use it. I have used this for many things eg ImageToXl . Use this in any Window you like, as long as you can get it's handle. Latter on (given time to write it) I will show how to use the SysAnimate32 control to display animation such as AVI files on a userform. I have these files but it is not ready for posting yet.
The comctl32.dll has these controls that I will show latter, in the mean time here is how to get a progress bar into your status bar area.
To use these controls you basically need to create a Window and Send messages to it via API's , and this is where the work goes in, BUT it is very simple when you know what to use and how.
The example below places a progress bar in the status bar area. You can, via the workbook control it's colour (background and fore colour) as well as the font of the text displayed.
To get an XP Style progressbar then look here (NB: You NEED Win XP)
| Class Name | Common Control |
| ToolbarWindow32 | Toolbar |
| tooltips_class32 | Tooltip |
| msctls_statusbar32 | Status bar |
| SysTreeView32 | Tree view |
| SysListView32 | List view |
| SysAnimate32 | Animation |
| SysHeader32 | Header |
| msctls_hotkey32 | Hot-key |
| msctls_progress32 | Progress bar |
| RICHEDIT | Rich edit |
| msctls_updown32 | Up-down |
| SysTabControl32 | Tab |
A computer science degree would be helpful if you want to modify Excel to meet your needs, though it isn't necessary. But since online degrees are easier than ever to get, why not give it a shot? You can take college classes online from home!
