Results 1 to 13 of 13

Listbox not working in Excel 2013

Threaded View

dghillza Listbox not working in Excel... 01-17-2014, 05:47 AM
Kyle123 Re: Listbox not working in... 01-17-2014, 07:05 AM
dghillza Re: Listbox not working in... 01-17-2014, 08:18 AM
Fotis1991 Re: Listbox not working in... 01-17-2014, 08:22 AM
dghillza Re: Listbox not working in... 01-17-2014, 10:03 AM
Norie Re: Listbox not working in... 01-17-2014, 10:13 AM
dghillza Re: Listbox not working in... 01-17-2014, 10:29 AM
Norie Re: Listbox not working in... 01-17-2014, 10:32 AM
dghillza Re: Listbox not working in... 01-17-2014, 11:18 AM
dghillza Re: Listbox not working in... 01-17-2014, 11:20 AM
dghillza Re: Listbox not working in... 01-17-2014, 11:21 AM
Norie Re: Listbox not working in... 01-17-2014, 11:24 AM
dghillza Re: Listbox not working in... 01-18-2014, 01:38 AM
  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    Western Australia
    MS-Off Ver
    Excel 2013
    Posts
    8

    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

    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
    Last edited by dghillza; 01-17-2014 at 10:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Working on Multiple Workbooks in Excel 2013
    By javaid in forum Excel General
    Replies: 1
    Last Post: 12-14-2013, 11:49 AM
  2. [SOLVED] Sort Data not working Excel 2013?
    By nobodyukno in forum Excel General
    Replies: 6
    Last Post: 08-14-2013, 10:31 AM
  3. Excel 2013 not Working on Windows 8 (Date & Time)
    By edison in forum Excel General
    Replies: 11
    Last Post: 06-23-2013, 09:59 AM
  4. Excel 2013 Conditional Formating not working
    By ExcelWombat in forum Excel General
    Replies: 3
    Last Post: 05-28-2013, 01:22 PM
  5. Link Excel 2013 to Word 2013
    By drosen99 in forum Word Formatting & General
    Replies: 20
    Last Post: 02-26-2013, 08:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1