LinkBack URL
About LinkBacks
I'm trying to add a listview to a userform, but when I drag the box onto the userform I get a "library not registered" error. How can I correct this. I'm using Office Excel 365, and the ListView control is version 6.0.
please help...
I'm trying to add a listview to a userform, but when I drag the box onto the userform I get a "library not registered" error. How can I correct this. I'm using Office Excel 365, and the ListView control is version 6.0.
please help...
Hello PerryBeatty,
I would guess that your version of Office 2013 is 64 bit. The ListView 6.0 control is a 32 bit library. As far as I know, Microsoft has not created nor intends to create a 64 bit version of this control.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
I am running the 32bit version of Microsoft Office 365. I've attached a couple of spreadsheets with a Listview, one was downloaded from the web and it works. I copied the VBA code fro that spreadsheet into one I created on my computer and it won't load the data into the listview. I'm stumped...
Perry
That references common controls 5. I don't have that on my system. You'll probably notice that you have a missing reference, I resolved by removing the missing reference and replacing the constants and strongly typed listview members with numbers and "objects" respectively. Or you could just reference the same version as the working example
I'm not sure how this works but the working version is using Microsoft Windows Common Controls 6 (Sp 6). The non-working version is using MWCC 5.
With only the non-working version open, there is a reference to MWCC 5 but obviously it doesn't work. It doesn't, however, say the reference is missing. BUT, I can't see MWCC 6 in the list of references.
When I open the working version, I can see MWCC 6 (near the top, not with the other Microsoft Windows stuff) and select it (and deselect MWCC 5).
Then it works.
Save it, close it, re-open it ... fine.
A puzzle
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Is this fixed?
Not yet...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks