| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What reference is needed to select the progress bar control?
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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
You need
Microsoft Windows Common Controls 6.0 (SP3) MSCOMCTL.OCX RBS "Michiel via OfficeKB.com" <u40062@uwe wrote in message news:8d6e83f418829@uwe... 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
Maybe you can use this:
http://www.cpearson.com/excel/Progress.htm "Michiel via OfficeKB.com" wrote: 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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 wrote: You need Microsoft Windows Common Controls 6.0 (SP3) MSCOMCTL.OCX RBS -- Message posted via http://www.officekb.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
Do Tools, References in the VBE, browse to that file and do OK.
RBS "Michiel via OfficeKB.com" <u40062@uwe wrote in message news:8d6f2b847df4e@uwe... 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 wrote: You need Microsoft Windows Common Controls 6.0 (SP3) MSCOMCTL.OCX RBS -- Message posted via http://www.officekb.com |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
Hi RBS, that is what I did but it is simply not in the list......
M. RB Smissaert wrote: Do Tools, References in the VBE, browse to that file and do OK. RBS Thank you! [quoted text clipped - 11 lines] RBS -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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 "Michiel via OfficeKB.com" <u40062@uwe wrote in message news:8d6f591806e27@uwe... Hi RBS, that is what I did but it is simply not in the list...... M. RB Smissaert wrote: Do Tools, References in the VBE, browse to that file and do OK. RBS Thank you! [quoted text clipped - 11 lines] RBS -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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" <u40062@uwe wrote in message news:8d6e83f418829@uwe... 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! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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. RB Smissaert wrote: 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? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
I have xl2003 SP3 and it is on my additional controls as Microsoft
Progressbar Control 6.0, also has 5.0 SP2 listed. "Michiel via OfficeKB.com" wrote: Hi RBS, that is what I did but it is simply not in the list...... M. RB Smissaert wrote: Do Tools, References in the VBE, browse to that file and do OK. RBS Thank you! [quoted text clipped - 11 lines] RBS -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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" <u40062@uwe wrote in message news:8d6f8617252f4@uwe... 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. RB Smissaert wrote: 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? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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. JLGWhiz wrote: 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 -- Message posted via http://www.officekb.com |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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. RB Smissaert wrote: 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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. "Michiel via OfficeKB.com" wrote: 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. JLGWhiz wrote: 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 -- Message posted via http://www.officekb.com |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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 ToolsReferences 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" wrote: 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. RB Smissaert wrote: 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
|
#16
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
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! -- Message posted via http://www.officekb.com |
|
#17
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference is needed to select the progress bar control?
Nice to hear this is solved.
I did have a feeling it would be something simple like this. RBS "Michiel via OfficeKB.com" <u40062@uwe wrote in message news:8d706b2ce3f74@uwe... 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! -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clickbox control help needed | Excel Programming | |||
| "Bouncing Bar" progress indicator control? | Excel Programming | |||
| Progress Bar - Help needed | Excel Programming | |||
| Microsoft Progress Bar ActiveX Control - Version 6.0 (SP4) - problems. | Excel Programming | |||
| Progress Bar Control | Excel Programming | |||
Linear Mode
