Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 08-30-2017, 09:57 PM
serge1p serge1p is offline Windows 10 Office 2016
Join Date: Aug 2017
Posts: 3
serge1p is on a distinguished road
Default MS Forms 2.0 library for 32 bit fails on x64

We have a template created in Excel (32-bit) that uses CommandButton in a Worksheet to open a UserForm. We send it out to clients, and they populate the spreadsheet via UserForm for a number of years now.

One client had recently got their Office reinstalled and now they use x64 Office.
When they try to open the template, it now fails with "Member or data member not found" compile error on the line where we set the button's caption.

When they checked references - none of them are broken (the smaller picture is from the client).
Please note that the spreadsheet works fine in 32-bit on the office 14.0

How can we make our template work on the existing 32-bit clients as well as for the new x64 client?

Attached Images
File Type: jpg ours.jpg (63.4 KB, 11 views)
File Type: jpg theirs.jpg (33.6 KB, 11 views)
Reply With Quote
Old 09-21-2017, 02:28 AM
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Posts: 154
Debaser is on a distinguished road

The MSForms library is compatible with 64bit, otherwise you would not be able to use userforms in 64 bit office. The most likely issue is that the .exd file on the local computer is storing a different control version.

I would recommend that you replace the button on the worksheet with a Form button rather than ActiveX - that should solve your problem.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help pls to create a book library megabyte Excel 2 07-17-2015 09:37 PM
Removing library view harry Office 0 02-13-2013 12:41 AM
Save As - why library ? Happy Word 0 03-15-2010 07:56 AM
Macro library pankajkankaria Excel 1 04-12-2009 09:06 AM
Access Object library 10 Gyto Office 0 10-09-2008 09:04 AM

All times are GMT -7. The time now is 04:48 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft