List View in Excel 2013 x64

tonydev314

New Member
Joined
Oct 1, 2022
Messages
26
Office Version
  1. 2013
Platform
  1. Windows
This is proving somewhat of a saga.
I first learned that for a while you couldn't do this because the type library containing the List View was only x86 compatible.
But then I read this which seemed to suggest you could do it:

SOLVED: MSCOMCTL.OCX Download & Register on 64 Bit Windows – Up & Running Technologies, Tech How To's

Then this post suggested I needed to run this code:
VBA Code:
cd C:\Windows\SysWOW64
regsvr32 mscomctl.ocx
regtlib msdatsrc.tlb

The regsvr32 command worked, but the regtib exe didn't exist, however I was able to find a copy of regtlibv12.exe from here
Running this against msdatasrc.tlb now worked successfully.
I rebooted and went into Excel - the mscomctl.ocx wasn't listed in References - I had to Browse to it, but when I added it as a reference, I got the error message "can't remove control or reference in use". Neverthless the component now showed up with a tick as Microsoft Common Control Library 6.0 (SP6)

However if I go into Form Additional Controls, List View is not there - none of the mscomctl controls are there.

Anyone able to assist?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top