Excel VBA Additional Controls not Working

I am in Trouble of Additional Controls of Userforms its not working i hv tried for mscomct2 file and mscomc2.ocx files and excel utility library all but not working please help me when i click on additional controls nothing happen and no menu opens up.

i have Version Ms Office 2013 at Laptop and 2016 at Office Desktop 2016 Both Have Same Problem.

Regards,
WiseOwl ExcelAsked:
Who is Participating?
 
Bill PrewCommented:
Some decent background on the situation here:

Missing Common Controls 6.0 (SP6)

As mentioned on the link below, in Office 32 bit you should still have the common controls installed.

Compatibility Between the 32-bit and 64-bit Versions of Office 2010

If you can't find them anyplace you could try downloading and installing them from:

Download Microsoft Visual Basic 6.0 Common Controls from Official Microsoft Download Center

What exactly is the problem you are having?  Do you have old VBA code that is now erroring out?  Is it when compiling, or when executing?  Anything else you can show or tell us about the problem to get better guidance?


»bp
0
 
Bill PrewCommented:
Are you using the 64 bit version of Microsoft Office?  If so then those common controls libraries are not support there, they only work in 32 bit versions of Office.


»bp
0
 
WiseOwl ExcelAuthor Commented:
At Office Desktop I Use 32Bit Windows 7 Version with Ms Office 2016 and At Laptop i User Ms Office with Windows 8.1 64Bit. Please Advice If 32bit.

Regards,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.