+ Reply to Thread
Results 1 to 14 of 14

Listbox auto fit column width

  1. 06-18-2013, 03:26 PM #1
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Listbox auto fit column width

    Hi

    I just want to know how to Autofit Column width of Listbox.

    Please help!!!

    Thanks
    Thiru
    Reply With QuoteRegister To Reply
  2. 06-18-2013, 03:50 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Listbox auto fit column width

    This seems to get it pretty close:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 06-18-2013, 03:53 PM #3
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    But the list box is in Userform - how to do that? - Please Help

    Thanks
    Thiru
    Reply With QuoteRegister To Reply
  4. 06-18-2013, 04:05 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Listbox auto fit column width

    If its name is still "ListBox1" the code should still apply - but, is it the same width as the userform - if so, then maybe you should use "UserForm1" instead??
    Reply With QuoteRegister To Reply
  5. 06-18-2013, 04:14 PM #5
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    Getting Error Msg

    This is the code that I have
    Please Login or Register  to view this content.
    Dim S As Single
    S = UserForm1.OLEObjects("ListBox1").Width / 6
    Columns("D:D").ColumnWidth = S * 1.077
    Reply With QuoteRegister To Reply
  6. 06-18-2013, 04:16 PM #6
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    Even I change the code - it doesn't work. 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 06-18-2013, 04:31 PM #7
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Listbox auto fit column width

    Can you post a sample spreadsheet with your userform including the listbox?
    Reply With QuoteRegister To Reply
  8. 06-18-2013, 05:01 PM #8
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    Please find the attached.

    Thanks
    Thiru
    Attached Files Attached Files
    Last edited by sthiru; 06-20-2013 at 02:39 PM.
    Reply With QuoteRegister To Reply
  9. 06-19-2013, 10:38 AM #9
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    Quote Originally Posted by xladept View Post
    Can you post a sample spreadsheet with your userform including the listbox?
    Any update sir?

    Thanks
    Thiru
    Reply With QuoteRegister To Reply
  10. 06-19-2013, 12:07 PM #10
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Listbox auto fit column width

    Hi SThiru,

    Your program trashed my system the first time I brought it up but subsequently I discovered that the list box width was 585.95 or something like that - when I ran my program on it it seemed to work - but I'm not sure now what you wanted.

    BTW - I posted this response, or a similar one yesterday - I have no idea why it didn't take
    Reply With QuoteRegister To Reply
  11. 06-20-2013, 02:34 PM #11
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    Its ok! I have found the solution - Below is the code for the people who searching for this.

    Please Login or Register  to view this content.
    Last edited by sthiru; 06-24-2013 at 08:21 PM. Reason: Additional Information
    Reply With QuoteRegister To Reply
  12. 06-20-2013, 03:29 PM #12
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Listbox auto fit column width

    Glad you got it!
    Reply With QuoteRegister To Reply
  13. 06-20-2013, 03:40 PM #13
    sthiru
    sthiru is offline
    Registered User
    Join Date
    05-22-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Listbox auto fit column width

    Quote Originally Posted by xladept View Post
    Glad you got it!
    Thank you xladept ;-)
    Reply With QuoteRegister To Reply
  14. 07-21-2021, 03:31 AM #14
    paperfold
    paperfold is offline
    Registered User
    Join Date
    04-10-2020
    Location
    greece
    MS-Off Ver
    2016
    Posts
    2

    Re: Listbox auto fit column width

    Autosize list/combobox columns with this function. Optionaly autosize the list/combobox itself. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1