Excel VBA Listview 5.0 and Listview 6.0

[laurawr]

Afternoon


What are the differences between Listview 5.0 and 6.0?

I am having problems with the Listview 6.0 in my vba coding & I have been advised to use 5.0.

Will I have to change my code for it to be compatible with 5.0?

Any input is appreciated.

Cheers L

 

[laurawr]

Does anyone have any ideas on this?

 

[laurawr]

Nobody Is helping so just to help this discussion move along a bit I am going to post some more info about my problem which has now progressed further,

Basically, I am usig a v6 listview control as a search facility on an excel userform (VBA)

Some of my colleagues when using this facility can see the listview, but some cannot ... as if it has disappeared :/

One of my colleagues has tried inserting a listview v5 as a test with no coding behind it and all people can see the listview. but when trying this with a v6 then again it disappears.

Now inserting a listview v5 seems like the easier option, However the v5 listview control does not support some of the features that I need that i can get from listview v6 control, so I need to fix this problem of the v6 listview disappearing on some pcs at work.

Has anyone got any ideas as to what could be causing the problem

Thanks
L

 

[sous2817]

Listview 5.0 is derived from comctl32.ocx and listview 6.0 from mscomctl.ocx. My guess the reason some people can't see the 6.0 version is because they don't have the mscomctl.ocx installed and / or registered on their machine.

As a test, you can try getting the mscomctl.ocx file from a machine you know shows the listview 6.0 and copy that to a machine you know doesn't have the file. Then follow the instructions here:

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

and see if the listview 6.0 now appears on that machine.

Completely untested, but seems like that's your issue.

Good luck!

 

[laurawr]

Thanks for getting back to me

I have heard that could be the problem from other colleagues but we havent tested it yet, due to me wanting to seek clarification online..

I will test it asap..


Thanks Again

L