Excel (32-bit) cannot get tools reference to 'Microsoft Windows Common Controls 6.0 (SP6)' - for use with ListView

In Excel 2010 (32-bit) with VBA7, I want to use ListView  (recommended in conjunction with an ImageList control), to enable user to click to choose items displayed as images.

However, Excel>Tools>references does not offer me Microsoft Windows Common Controls 6.0 (SP6). Excel>Help confirms my excel is 32-bit.

Is there a way around this?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
If you want to use the listview control in a userform you'll find that it's a standard part of the Toolbox.
In UserformAnd in a sheet go to the Developer tab, click Insert
moreand then click the "...".

In sheet
Kelvin4Author Commented:
Thanks, Martin.
I got the ListView to download to Worksheet, as you described, but the icons in the UserForm Controls toolbox remain unchanged and very limited (below). Is there a further step for me to show a listView in a UserForm?


This shows the toolbox for my Excel 2010 UserForm.
Martin LissOlder than dirtCommented:
Ahhh, it's been so long that I didn't remember adding it.

Right-click on the Toolbox and select Additional controls.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Kelvin4Author Commented:
I read this, do you think is it relevant? Its to repair a missing "Monthview" Control.   [Kelvin


---------- One section from George Zhao [TechNet Community Support] read as follows, -------------

Method 2 | The "Monthview" Control doesn't currently exist

Close Excel
Download MSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
Extract Both Files | the .inf file and the .ocx file
Install | right-click the .inf file | hit "Install"
Move .ocx file | Move from "C:\Windows\system32" to "C:\Windows\sysWOW64"
Run CMD | Start Menu -> Search -> "CMD.exe" | right-click the icon | Select "Run as administrator"
Register Active-X File | Type "regsvr32 c:\windows\sysWOW64\MSCOMCT2.ocx"
Open Excel | Open VB Editor
Activate Control | Tools->References | Select "Microsoft Windows Common Controls 2-6.0 (SP6)"
Userform Controls | Select any userform in VB project | Tools->Additional Controls
Select "Microsoft Monthview Control 6.0 (SP6)"
Use 'DatePicker' control for VBA UserForm

George Zhao
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.
Kelvin4Author Commented:
Your last ///// oops crossed with you ...... opening ......
Kelvin4Author Commented:
Very quick and complete help,
Much appreciated!

Now to work out how to use it!
Kelvin4Author Commented:
If you can help - I'm posting another Q re ListView.
Looking for a firm starting point to develop Listview skills.

Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest youincluding these two new ones.
An Experts Exchange Shortcut for the Truly Lazy (for Apple OS X)
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.