What reference is needed to select the progress bar control?

[Michiel via OfficeKB.com]

I used it many times before, the Progress Bar Control.
I selected it from the Toolbox and dragged it onto a form.

Now it is not in the toolbox anymore. I guess I need to set a reference, but
which one in the list of hundreds?

Who can help me?, please!

Thanks!

 

[RB Smissaert]

You need
Microsoft Windows Common Controls 6.0 (SP3) MSCOMCTL.OCX

RBS

 

[JLGWhiz]

Maybe you can use this:

http://www.cpearson.com/excel/Progress.htm

 

[Michiel via OfficeKB.com]

Thank you!

I can locate the MSCOMCTL.OCX file on my drive. The "Microsoft Windows Common
Controls 6.0" reference, however is not in the list.
I am using Excel 2003 SP3

Any ideas?

M.

 

[RB Smissaert]

Do Tools, References in the VBE, browse to that file and do OK.

RBS

 

[Michiel via OfficeKB.com]

Hi RBS, that is what I did but it is simply not in the list......

M.

Do Tools, References in the VBE, browse to that file and do OK.

RBS

Thank you!

[quoted text clipped - 11 lines]

 

[RB Smissaert]

Did you find the file in C:\WINDOWS\SYSTEM32\ ?
What version was it? I got 6.1.97.86
What is your Windows type/version?
Can you compile the file as it is?

RBS

Hi RBS, that is what I did but it is simply not in the list......

M.

Do Tools, References in the VBE, browse to that file and do OK.

RBS

Thank you!

[quoted text clipped - 11 lines]

RBS

 

[Peter T]

Right click the control toolbox
Additional controls....

scroll down until you find

Microsoft ProgressBar control 6.0 (SP6)
you might also see 5.0 (SP2)

There are slight differences in how each control behaves, the later 6.0
should OK in most systems.

Put a tick in the box.

Regards,
Peter T

 

[Michiel via OfficeKB.com]

Hi again!

File location: C:\WINDOWS\SYSTEM32\
Version: 6.1.95.45
OS: Windows XP Professional SP2

I do not know how to compile the file as it is....

M.

 

[JLGWhiz]

I have xl2003 SP3 and it is on my additional controls as Microsoft
Progressbar Control 6.0, also has 5.0 SP2 listed.

Hi RBS, that is what I did but it is simply not in the list......

M.

Do Tools, References in the VBE, browse to that file and do OK.

RBS

Thank you!

[quoted text clipped - 11 lines]

RBS

 

[RB Smissaert]

I do not know how to compile the file as it is....

In the VBE, Debug, Compile
The reason I ask about compiling is that I think that if there is something
seriously wrong with the project then
you may not be able to add the reference.

RBS

 

[Michiel via OfficeKB.com]

Hi JLGWhiz, thanks you as well for your replies and suggestions.

I wish I could send attach a screendump in this formum, I cannot see anything
like that.

M.

I have xl2003 SP3 and it is on my additional controls as Microsoft
Progressbar Control 6.0, also has 5.0 SP2 listed.

Hi RBS, that is what I did but it is simply not in the list......

[quoted text clipped - 9 lines]

 

[Michiel via OfficeKB.com]

Hi RBS. Yes I tried that and it complies perfectly.
To make sure I closed excel, opened a new workbook, went into the Code editor,
added a form and the Toolbox. I compliled this codeless project and then
tried to find the reference. But again, not in the list.

M.

 

[JLGWhiz]

Maybe the problem is in communication. You and RB keep referring to the DLL
library references. I don't find it in my references either, but it is in my
additional controls from the Control Toolbox Toolbar in Excel, NOT the VBE.
So it has to be in the reference library under a different name. But if you
have lookded in the Control Toolbox Additional Controls and cannot find
Micosoft Progressbar Control 6.0 then ignore this message, because I don't
know where else you would find it.

Hi JLGWhiz, thanks you as well for your replies and suggestions.

I wish I could send attach a screendump in this formum, I cannot see anything
like that.

M.

I have xl2003 SP3 and it is on my additional controls as Microsoft
Progressbar Control 6.0, also has 5.0 SP2 listed.

Hi RBS, that is what I did but it is simply not in the list......

[quoted text clipped - 9 lines]

RBS

 

[JLGWhiz]

This might help. In Excel, I used View, Toolbars, Control Toolbox then
clicked the icon for more controls. From the dropdown list, I fount
Microsoft Progressbar Control, version 6.0 and clicked on it. I depositied
the control on a sheet, reviewed the properties and then deleted it. Then I
went to the VBE Tools>References and lo and behold there it was, Microsoft
Windows Common Controls 6.0 (SP6). I had looked everywhere for that entry
before and could not find it. Rots o ruck!

 

[Michiel via OfficeKB.com]

PROBLEM SOLVED!!!!!

Hi all, thanks so much for all your help!
I finally found the solution...

The reference "Microsoft Windows Common Controls 6.0" does exist but it
appears to be almost at the bottom of the list and not near the other
references that start with "Microsoft".
I found it by doing this:

Tools\References
Browse Button
Browse to and select the file mentioned by RBS
Then the Microsoft Windows Common Controls 6.0 all of a sudden revealed its
location.

Thanks again!

P.S. Peter T. Your contribution came in between two mails so I overlooked it.
Thanks for you as well!

 

[RB Smissaert]

Nice to hear this is solved.
I did have a feeling it would be something simple like this.

RBS