Listbox not working in Excel 2013

Hello all,

I have created a spreadsheet that contains a host of custom built features, one of them being a form that populates two Listboxes. The whole thing works perfectly in Excel 2010 but the moment I open it up in 2013 I get the following message "could not load some objects because they are not available on this machine" So I've gone as far as I could to load MSCOMCTL.OCX / FM20.DLL and tried to identify others from the references -VBAProject
In Excel 2013 after the error the listboxes on the user form are not there and even if I exit without saving and then load the spreadsheet in excel 2010 they gone. I do keep a backup which I keep going back to in an effort to try resolve this.
The next thing I tried was to just add the list boxes to the Userform - which is fine but then it fails on the properties of the ListBox:

This is part of my code and it get's stuck on .ColumnHeaders.Clear

Please Login or Register  to view this content.

From what I can gather that the listbox in Excel 2013 doesn't contain the properties Columnheaders and the only one I find in ColumnHead but that doesn't work either.

So now I'm stuck and if any one could help me I'd be most grateful
And thank you in advance

Darren

. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Darren

As far as I know the ListView control isn't standard in any version of Excel.

If you use one in a workbook which is distributed to others then people who have no access to the control are going to have problems.

Is there some reason you can't use a listbox?

A listbox can have headers though you would need to populate it from a range.

Why not try a work around like having a listbox for the headers?

That could be placed just above the listbox for the data and have the same column widths.

Might sound a bit clunky but it actually works quite well.