+ Reply to Thread
Results 1 to 3 of 3

Setting individual column width sizes for multi column listbox with VB2011 Mac not working

  1. #1
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Setting individual column width sizes for multi column listbox with VB2011 Mac not working

    Im working with Excel 2011 on a Mac.
    Im trying to use the following VB code to set the column width size for a multi column List Box:
    Please Login or Register  to view this content.
    However each column is appearing to be exactly the same size. Is this some sort of bug with Excel, or is the code different?

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Setting individual column width sizes for multi column listbox with VB2011 Mac not wor

    Widths should be separated by semicolon and not comma.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Setting individual column width sizes for multi column listbox with VB2011 Mac not wor

    Thank you Izandol.

+ 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] Multi Column ListBox - set output formats for each column?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-10-2020, 10:27 AM
  2. Matching a column of shaft sizes to a column of hole sizes to find best match for all
    By BrettRCourtney in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2013, 11:25 AM
  3. Excel 2007 : VBA to change multi-column width
    By Schan in forum Excel General
    Replies: 1
    Last Post: 07-27-2011, 04:49 PM
  4. [SOLVED] Setting column width if #### appears in column
    By qwerty in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-09-2006, 11:10 AM
  5. [SOLVED] can we make a column width different sizes on the same page?
    By karen in forum Excel General
    Replies: 2
    Last Post: 10-19-2005, 06: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