+ Reply to Thread
Results 1 to 5 of 5

ListBox.List(ListBox.ListCount -1, 10) PROBLEM

Hybrid View

Roque_Trinidad ListBox.List(ListBox.ListCount... 02-07-2024, 12:57 PM
romperstomper Re:... 02-07-2024, 01:01 PM
romperstomper Re:... 02-07-2024, 01:08 PM
Roque_Trinidad Re:... 02-07-2024, 01:21 PM
Roque_Trinidad Re:... 02-07-2024, 01:18 PM
  1. #1
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,015

    Re: ListBox.List(ListBox.ListCount -1, 10) PROBLEM

    You can only use 10 columns if you use AddItem to populate the listbox. You need to either use a range and the RowSource property or use an array assigned to the List/Column property if you need more columns.
    Last edited by romperstomper; 02-07-2024 at 01:03 PM.
    Everyone who confuses correlation and causation ends up dead.

+ 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] listbox to listbox data transfering problem
    By rukman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-13-2017, 07:26 PM
  2. Listbox.listcount property - application defined or object defined error
    By JulyMoon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2015, 04:30 PM
  3. Listbox LISTCOUNT propery problem
    By Skitzee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2014, 09:56 AM
  4. [SOLVED] How do I populate a listbox with a list excluding values found in another listbox?
    By Hokiefan00 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2014, 01:47 PM
  5. Incorrect ListCount value in ListBox
    By BLLMRC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 01:03 PM
  6. 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
  7. dynamic listbox -- manually change .ListCount property
    By naznorb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2012, 10:42 AM

Tags for this Thread

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