Forum Discussion
Excel2016 win10 64bit userform
hallo,
i use excel-makros since 15 years, include userforms.
now i changed from office2010 to office2016 on my win10 64bit and i have trouble with excel.
when i want to open an excel-workbook an errormessage acurt, that this is not possible.
then i open a new workbook and build a makro, thats fine. but i cannot insert an UserForm.
the error 336 , active-x komponent not right registered.
i deinstall the office with the microsoft clean-deinstallation and install again.
on a second win10 64bit Office2016 pc everything is ok, i see no different.
i tried regsvr32 FM20.DLL and others, no chance.
any ideas?
sorry for my bad englisch , i'm a german.
walter
- Have you checked vba project references?
Alt + F11 > Tools > References- yes, in excel-vba references is no microsoft forms. i musst searche fm20.dll manually. but where is the right one, in syswow64 or in system32 or anywhere else? both tried, same problem.
by the way, in outlook and word it works.
thanks for help.
walterI don't have Excel 2016. However, I searched some articles on webs. One does make senses that if you add a new userform, excel will automatically add the reference for you, and then you can delete the new inserted-form.
Reference:
https://stackoverflow.com/questions/35610429/why-do-i-not-see-the-microsoft-forms-2-0-object-library
