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 ExcelFinance ExxcutiveAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewIT / Software Engineering ConsultantCommented:
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 ExcelFinance ExxcutiveAuthor 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
Bill PrewIT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.