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 a...
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.
walter
by the way, in outlook and word it works.
thanks for help.
walter
I 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
- ok,
next try, office2016 deinstall manualy with all the pretty small delete and deregister options from the microsoft supportpages. restart and, what a surprise, nothing changed. no userform in excel.
walter- hi again,
the solution is quick and dirty.
a systemadmin told me to deinstall the office2016 64bit with the fixit-tool from MS, then some starts off my win10 64bit to delete other old office-fragments with fixit, then reinstall but the 32bit version of office2016.
and what a surprise, everything is ok again. my userform are ok.
thanks for help and goodby.
by the way, for me that looks not so good for MS.
walter
Hallo Walter,
normally, UserForms using the MS standard controls should work on both Excel 32 Bit and 64 Bit without problems. An exception for Excel in 64 Bit is, for example, if there are additional external controls on the UserForm which are 32 Bit only, such as a ListView, a ProgressBar or a TreeView which come from the mscomctl.ocx library. Do you have such controls on your UserForms?
Best,
Mourad
