VBA Excel 2016 MSI 64 Bit - Problem with ListView element (MSCOMCTL.OCX)

Question

Dear community,

This topic might be not new, but I've been searching for days and still couldn't find a solution to my problem, so I wanted to post it here - much appreciate if you could help:

I developed an Excel VBA application for my client, in which I used the Microsoft ListView Control (MS Windows Common Controls 6.0 SP6). It is included in the library MSCOMCTL.ocx (see screenshot below):

My problem: the file runs perfectly on my computer (Windows 10, Office 365 64Bit), but when I sent it to my client (Windows 10, Office 2016 MSO version 16.0.4266.1001, 64 Bit, installed using MSI package), the following error popped up when the Userform is run:

When opening the VBE of the client, we see that the library is missing:

We then tried following different options, but without success:

1. Install the missing mscomctl.ocx with the MS download link:

https://www.microsoft.com/en-us/download/details.aspx?id=10019

-> did not work

2. Copy the "mscomctl.ocx", which is extracted from the file downloaded in the link above, to C:\Windows\SysWow64 of the client, and then register the "mscomctl.ocx" using Cmd or Powershell (run as Administration) and the command regsvr32 C:\Windows\SysWow64\mscomctl.ocx

-> now the reference is not shown as "MISSING" anymore, but the error "Could not load an object because it is not available on this machine" still occurrs.

-> still did not work.

I then found this which is posted in 2017:

https://social.technet.microsoft.com/Forums/en-US/b0cbd382-b556-4a5c-9e8e-9762343f9225/mscomctlocx-64bit-support-for-mso-version?forum=Office2016setupdeploy

and I'm not sure whether it is still up-to-date (whether the MSCOMCTL.OCX still does not support Office 2016 MSI 64 Bit).

Would be very thankful if anyone of you know a solution.

Thanks and best regards,

Kim

Answer 1

Hi, @Kim Yong Min
After my search, Microsoft has not updated mscomctl.ocx (64-bit) for Excel 2016 MSO version. It is recommended that you submit feedback at feedback.Thanks for your understanding.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.