+ Reply to Thread
Results 1 to 9 of 9

Userform Listbox to display selected column

  1. #1
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Userform Listbox to display selected column

    Hi,

    Can anyone help me to display multiple range of data in Userform Listbox? The ranges are in interval condition
    Also, the problem to display up to 2nd decimal point in column SZ


    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Re: Userform Listbox to display selected column

    hi,

    Anyone help me please

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Userform Listbox to display selected column

    Quote Originally Posted by Faridwahidi View Post
    hi,

    Anyone help me please
    You might get a better response if you post the actual sheet.


    ViewPic

  4. #4
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Re: Userform Listbox to display selected column

    Hi skywriter,

    Attached my workbook. I need to display data for 20 columns. Also, I have no idea how to display data header due to it has been merged with several cells.

    On the last columns, I would like to display score value up to 2nd decimal points but it does not work.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Userform Listbox to display selected column

    See how you like this.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Re: Userform Listbox to display selected column

    Hi skywiter,

    Thanks for willing to help me,

    However, copy data and put in a new sheet in order to remove the column interval not the approach I am looking for. It makes the program running slightly slow. My actual workbook have many worksheets and various data.

    I would like to have VBA code to be able display directly from actual data.

    let's say for this code, how to display MyList1,2,3 directly
    Please Login or Register  to view this content.
    Last edited by Faridwahidi; 06-24-2015 at 11:44 AM.

  7. #7
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Userform Listbox to display selected column

    Okay, good luck.
    Last edited by skywriter; 06-24-2015 at 12:58 PM.

  8. #8
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Userform Listbox to display selected column

    maybe something like this
    Please Login or Register  to view this content.

  9. #9
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Re: Userform Listbox to display selected column

    Hi nilem,

    It works fine. you are an expert. Thanks a lot.

+ 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] Add Selected Items From One ListBox to Another ListBox on UserForm
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 06:53 PM
  2. Put a selected row into a listbox in a userform
    By sebastienkanj in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-09-2013, 08:23 AM
  3. VBA - Populate Listbox based on value selected in another ListBox (On Userform)
    By raaboo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-12-2012, 11:18 AM
  4. Populate userform listbox based on value selected in another listbox
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2012, 05:16 PM
  5. Display a UserForm based on Data selected in another UserForm's ListBox
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2011, 11:35 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