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
With UserForm8.ListView1
.ColumnHeaders.Clear
.ListItems.Clear
.ColumnHeaders.Add , , "Date", 80, lvwColumnLeft
.ColumnHeaders.Add , , "Amount", 60, lvwColumnRight
.HideColumnHeaders = False
.View = lvwReport
.Gridlines = True
.FullRowSelect = True
.View = 3
For c = 1 To l
.ListItems.Add , , strArray(c - 1, 0)
.ListItems.Item(c).ListSubItems.Add , , strArray(c - 1, 1)
Next c
End With
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
Bookmarks