+ Reply to Thread
Results 1 to 3 of 3

Multiple Columns Including the Header to display in Listbox

  1. #1
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Multiple Columns Including the Header to display in Listbox

    Hello Gurus,


    Could you please help me with my problem.

    I have a userform with Listbox. My problem is, i can't display multiple columns in the Listbox.

    I have the below code but it only display only one column and also not displaying the header.
    Please Login or Register  to view this content.
    I want to display Columns A, C & D including the header with 'WAITING FOR APPROVAL' status.
    So it will display like this:

    Name | Letter | Double
    LESS A AA
    MORE C CC
    EXCLUSIVE D DD
    NONE E DD

    I have attached my file. Thanks in advance gurus!
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Multiple Columns Including the Header to display in Listbox

    This will populate the listbox but as I've said previously you can't have a header unless you are populating the listbox from a range via RowSource.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Re: Multiple Columns Including the Header to display in Listbox

    It fits perfectly Norie! You're a genius! Thank you so much!

+ 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. ListBox in Excel on basis of cell
    By nitesh_greatie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 02:22 AM
  2. Replies: 2
    Last Post: 10-13-2012, 03:30 AM
  3. How to hide all empty columns without including the column header
    By mkingsberry in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2010, 12:27 PM
  4. Is there a way to display a cell information in the header of multiple sheets?
    By elgourmet in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-20-2010, 06:20 AM
  5. How do I sum multiple columns counting including blanks and dates
    By BK99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2005, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1