Forum Discussion
Excel2016 win10 64bit userform
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
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
- Walter KnippJan 26, 2018Copper Contributorhi 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- AnonymousJan 26, 2018
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
- Walter KnippJan 26, 2018Copper Contributor
hallo again,
no ther are only Textboxes Labels and an Image and one ListBox in the two UserForm's.
The Microsoft Form 2.0 ObjektLibary is set on C:\Windows\SysWOW64\FM20DLL.
This may be wrong but it works.
walter