Forum Discussion
Walter Knipp
Jan 19, 2018Copper Contributor
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...
Walter Knipp
Jan 26, 2018Copper Contributor
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
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
Deleted
Jan 26, 2018Hallo 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