1

I am trying to add a progress bar to my User form but it is giving me "Library not registered" error. What I do is the following:

First I add the progress bar to the toolbox from Tools -> Additional controls

enter image description here

I choose the progressBar from Toolbox options and try to put it in the userForm

enter image description here

It gives me the error:

enter image description here

Apparently I have to add a Library from Tools -> References but I don't know which one is the one that is needed. I google it and I found that the MSCOMCTL.OCX could be the one that I needed but I add this one and I already have the same error.

Someone know which one is the correct?

EDIT

I put my references list so you can see what I am using:

enter image description here

Iban Arriola
  • 2,526
  • 9
  • 41
  • 88
  • Please help us reproduce your problem if you want us to help you solve it. http://sscce.org/index.html – Jean-François Corbett Dec 23 '13 at 14:26
  • I put more explanation... hope that this will be enough to understand what is going on and to reproduce it. – Iban Arriola Dec 23 '13 at 15:40
  • are you using the 32 bit or 64 bit Office 365 version? The reason I ask is, I'm pretty sure a lot of the controls in MSCOMCTL.OCX aren't supported in 64-bit office installs (http://www.slyman.org/blog/2010/11/64-bit-windows-7office-2010-migration-experiences/) . – sous2817 Jan 03 '14 at 18:36

2 Answers2

0

you need a reference to Microsoft Windows Common Controls 6.0 (SP6) to utilize the Progress bar. This should have been added when you selected the progress bar.

EDIT Register it.

open a command prompt with admin creds and type in

regsvr32 /s MSCOMCTL.OCX

EDIT#2 on a 64bit machine under admin creds in a command prompt.

cd C:\Windows\SysWOW64\
regtlib msdatsrc.tlb
Sorceri
  • 7,870
  • 1
  • 29
  • 38
0

Do you have VB6 or some other programming language installed on the system? One that shipped with MS Windows Common Controls 6 (SP6)?

IIRC some of these controls can run on any system so long as they're properly installed and registered but can only be used to design/create code on a system where the language they shipped with is installed.

Others controls are compatible with VB but not VBA forms.

With very little extra work, you can create a reasonable progress bar from two text boxes or labels and a bit of code. Lighter weight, requires no installation/registration at the user end.

Steve Rindsberg
  • 14,442
  • 1
  • 29
  • 34