Results 1 to 8 of 8

Thread: Maximum columns in a ListBox

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 12-17-2011, 09:31 PM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Rasm,

    Rather than looping all those cells, why don't you use variant array like I did in my post above ?

    BTW, I tested 50 columns and works fine.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 12-17-2011, 09:50 PM #2
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    15
    Admin
    You are right - thanks - that is what I will do.
    Rasm
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Wrap Text On Spaces Up To A Maximum Number Of Characters Per Line
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 15
    Last Post: 12-20-2016, 09:47 AM
  2. Find Maximum Value Corresponding To Adjacent Column
    By shonu in forum Excel Help
    Replies: 6
    Last Post: 05-22-2013, 02:23 AM
  3. Change listbox value
    By Tony in forum Excel Help
    Replies: 4
    Last Post: 12-04-2012, 08:58 PM
  4. Hide/Unhide Columns with Listbox
    By obed_cruz in forum Excel Help
    Replies: 2
    Last Post: 05-28-2011, 07:26 PM
  5. Using ListView - a Listbox on steroids
    By Rasm in forum Download Center
    Replies: 3
    Last Post: 04-09-2011, 03:34 AM

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
  •  

Forum Rules