+ Reply to Thread
Results 1 to 7 of 7

ListBox Multiple Specific Columns Shown in UserForm

  1. #1
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Question ListBox Multiple Specific Columns Shown in UserForm

    listbox edit 3.xlsm

    I need to only have columns B, C, D, E, and G (these 5 columns) in the ListBox1 on the UserForm1. I want these columns to be specific to be shown.

    Please help. Thank you!!

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: ListBox Multiple Specific Columns Shown in UserForm

    Hello,

    One easy way would be to set the column size on the list box and put 0 for column F

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: ListBox Multiple Specific Columns Shown in UserForm

    Lets just say I want columns B, C, D, N and O?

    The only problem is when I view the UserForm1 I only see column B and C shown in the first and second location (column) of the ListBox. Is there a property change that needs to be made?

    Is the code like this
    Please Login or Register  to view this content.
    Thank you!

  4. #4
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: ListBox Multiple Specific Columns Shown in UserForm

    Hi,

    The other properties to change would be
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: ListBox Multiple Specific Columns Shown in UserForm

    It still only shows 2 columns and not all 5 columns in the ListBox. Here is my code. Is there another property I need to change?

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: ListBox Multiple Specific Columns Shown in UserForm

    This seems to work for the UserForm_Initialize()

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: ListBox Multiple Specific Columns Shown in UserForm

    The only other issue I'm having is if I switch from Item 1 to Item 2, the OptionButton is not dynamic and doesn't update.

    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] How show in Listbox (userform) specific files
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-31-2015, 10:12 AM
  2. [SOLVED] Vlookup in UserForm - Get Input from listbox, Lookup in specific table from specific sheet
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 09:00 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. [SOLVED] listbox on userform not showing specific cells
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2013, 12:29 PM
  5. userform listbox
    By tsiguy96 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2013, 11:09 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