Excel VBA - ListView - Clicking (Custom) property generates "Class Not Registered" error

Question

Using Excel 2007 VBA - attempting to place a ListView control on a Userform.  When I click the "(Custom)" property to define the columns, I get a "Class Not Registered" error (along with ancillary error info 'Looking for object with CLSID:{7EBDAAE1-8120-11CF-899F-00AA00688B10}').

A search of the Microsoft Knowledge Base found a similar problem (KB 814707), but their solution did not work for me. I could not even locate the DLL they refer to (MSBind.dll) on my computer (and it's not clear to me that it's a binding issue anyway).

The ListView properties can be set in code and seem to work just fine, but I was wondering if anyone knew if it's possible to use the custom designer from with Excel VBA.

Thanks,
Mark

Answer 1

Hello,

As this KB shows you could resolve the issue by manually use RegSvr32 utility to manually register the Msstkprp.dll.

http://support.microsoft.com/kb/188331

Thanks.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Tim,

That KB article sure looks like the solution to the problem but, unfortunately, Msstkprp.dll is not present on my computer, and we are prohibited from downloading anything.  So, I'm going to have to go through channels to get this DLL on my computer.  I'll register it and test when that is complete and, hopefully, the problem will be solved.

Thanks,
Mark

Answer 3

Tim,

Thanks again for your help, but just wanted to post a follow-up on this one.  I finally got Congressional approval to copy this Msstkprp.dll to my Windows\System folder and register it.  However, it did not solve the problem.  Same error.

Thanks anyway,
Mark

Answer 4

Tim,

LATEST UPDATE -

Registering the MSSTKPRP.DLL will, in fact, fix the problem. 

I decided to double-check and discovered that the "admin" user did not register msstkprp.dll.  God only knows what he actually registered, but it wasn't that dll.

Once it was registered correctly, the problem went away.

-Mark

Answer 5

I too have problems with this. It bugs me.

Im a complete newbie on VBA coding in Excel 2007, or any VB code.
I need a ListView that's capable of selecting multiple items and return the value of the item, I found a lot of tutorials and after 3-4 hours I realized that I had to add the control ListView 6.0. When using the custom link I get the same issue..

So, I of course followed your advises, since I dont use any purchased version of Visual Studio and couldnt find the file on our Office Enterprise CD, I downloaded it from the net.
I found several sites providing the file and compared them to one another and they all match, so I trust it to be the correct DLL file.
I copied it to the system and system32 directory, just to be sure, and then I ran the RegSvr32. Im on Windows 7, and no go.

Please advise something asap as Im trying to hold my deadlines :)

Cheers
Viktor

Answer 6

I was able to get a ListView to work in Excel VBA by setting a reference to Microsoft Windows Common Controls 6.0 (SP6) which I found by browsing to C:\Windows\SysWOW64\MSCOMCTL.OCX on my Windows7 pc.

---

Have a great day!

Answer 7

Thanks a ton...I can't tell you guys .. this actually resolved my issue...I did each and every step I found in last 3 days including reinstalling Windows 10, MS office, FM20.dll, COM edit etc......at last I m happy to see the options in list view of my form in VB. so relaxing without any error when I clicked on customer view.....Thanks a ton for sharing the solution.... "Download msstkprp.dll in Windows\SysWOW64 and then simple register it with Admin rights in Command Prompt"...…

- UB