+ Reply to Thread
Results 1 to 4 of 4

Userform Listbox error

  1. #1
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Userform Listbox error

    Greetings,

    I am actually stuggling to solve the error, but I ended up needing your little help on it. I am using a dropdown/combo box to populate a listbox automatically, and I am calling all available column needed on the list. I can load up to 10 columns but when I am trying to add more columns all I get is an error of "Could not set the list property. Invalid property value."

    On the code below, I will highlight in bold whenever I encounter the error. Thanks for the help guys.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Userform Listbox error

    Lot easier to work with a copy of your actual workbook.
    See big yellow banner at head of page - how to upload your workbook.
    There are a number of reasons, firstly your code, secondly what properties have you set for the listbox, etc., etc.,
    Help us to help you with minimum guess work.
    torachan.

  3. #3
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Userform Listbox error

    Quote Originally Posted by torachan View Post
    Lot easier to work with a copy of your actual workbook.
    See big yellow banner at head of page - how to upload your workbook.
    There are a number of reasons, firstly your code, secondly what properties have you set for the listbox, etc., etc.,
    Help us to help you with minimum guess work.
    torachan.
    @torachan apologize, I have to secure the data first and replace it with dummy data. Anyway here is the actual dummy file I created. thanks.
    Attached Files Attached Files

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Userform Listbox error

    start your listbox column columns from "0" (zero) not "1" (one) you will then get 10 columns
    However the Additem method is not the ideal in a situation that you are dealing with.
    My personal opinion would be to dispense with listbox headers (use labels positioned above the listbox)
    Then familiarise yourself with using tables for your data and array loading your listboxes and comboboxes.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform listbox adding rowsource runtime error 380
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2016, 02:10 PM
  2. [SOLVED] List of items in a userform listbox, object required error in code
    By jayherring86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2015, 09:10 AM
  3. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  4. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  5. [SOLVED] Userform Listbox to Activesheet.Range(Activecell.address).Value Error
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-26-2012, 04:59 PM
  6. Error in populated listbox userform
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2010, 09:54 PM
  7. Passing Userform Listbox to sub causes type-mismatch error
    By Kleev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2005, 04:05 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