Comile Error: Can't find project or library

Please can someone help me with this.

One of our employees has wrote a VB project in excel 2010 which works on some machines and not others, it comes up with the below error message.

I have checked VB and there are no missing references.

Compile Error: Can't find project or library


Private Sub UserForm_Initialize()

'Empty ClientCodeComboBox
Me.ClientCodeComboBox.Clear

'Fill ClientCodeComboBox
Me.ClientCodeComboBox.List = Worksheets("Index").Range("A2:A" & Worksheets("Index").UsedRange.Rows.Count).Value

'Prepare CompanyCodeBox.Caption
Me.ClientNameLabel.Caption = ""

'Uncheck CompanyCodeCheckBox
Me.CompanyCodeCheckBox.Value = False

'Clear YearEndDateBox
Me.YearEndDateBox.Value = Date
Me.YearEndDateBox.MaxDate = Date

'Clear ScanDateBox
Me.ScanDateBox.Value = Date
Me.ScanDateBox.MaxDate = Date

Yes looked under references but nothing missing. I'm assuming you just mean VB references.

References set in the project are:

Visual Basic for Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Windows Common Controls-2 6.0 (SP4)

"YearEndDateBox" and "ScanDateBox" are DateTimePicker controls.

All machines are using office 2010

Yes im checking my computer which it errors on.

I installed the Microsoft Windows Common Controls-2 6.0 (SP4) reference manually yesterday as it said it was missing.

Now when I check references it does not say missing and points to the required file.

Yes the computer still errors, I downloaded it from Microsoft website and pointed it to the location required. C:\Windows\SysWOW64\mscomct2.ocx

I've download the cab file from Microsoft and extracted the ocx file to C:\Windows\SysWOW64.

I then ran the following command from the command prompt logged in as Administrator.

regsvr32 C:\Windows\SysWOW64\mscomct2.ocx and received the message it had been registered successfully, but it still didn't work.

I've ran revDllView to see if the file is loaded but it isn't.

Any other suggestions?

Thanks

Yes it is Office 32Bit

Not exactly sure what you mean by "Do you see controls on userform in design view?"

Please can you help me further.

Capture.PNG Please see attached image.

We have the exact same spread sheet working on another machine. Some machines it works on and some it does not.

I am trying to get to the bottom of why?

What would you recommend instead of using common controls for the user form.

Thanks I will let you know how I get on.