+ Reply to Thread
Results 1 to 10 of 10

Multi Column Listbox change based on a selection from a combobox

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question Multi Column Listbox change based on a selection from a combobox

    Dear All,

    I have attached my Excel File with the userform I am trying to do. What I am trying to do is change the table in the listbox based on the selection of the combobox and then my selection in the listbox will pass the selected values to Range A1:C1.

    Thank You in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-21-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Multi Column Listbox change based on a selection from a combobox

    Could anyone help me please regarding this?

  3. #3
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Multi Column Listbox change based on a selection from a combobox

    i have reviewed your sheet, but im not sure what your desired output is, could you give a little more detail?
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  4. #4
    Registered User
    Join Date
    02-21-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Multi Column Listbox change based on a selection from a combobox

    Quote Originally Posted by DGagnon View Post
    i have reviewed your sheet, but im not sure what your desired output is, could you give a little more detail?
    I want for each selection in the ComboBox i.e. Choice 1, Choice 2,..... the table in the list box change to the corresponding table which is different for each selection. And then If i select a row from the listbox the selection will appear at cells A1:C1

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Multi Column Listbox change based on a selection from a combobox

    make each table a Dynamic amed Range, using the values in the ComboBox as the names. Then use the ComboBox value to choose the RowSource
    Attached Files Attached Files
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Registered User
    Join Date
    02-21-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Multi Column Listbox change based on a selection from a combobox

    Quote Originally Posted by royUK View Post
    make each table a Dynamic amed Range, using the values in the ComboBox as the names. Then use the ComboBox value to choose the RowSource
    That is Great royUK, very smart solution. Only small thing is remaining that I want pass the values of the selected row in the listbox to range A1:C1.

    Your help is very appreciated.

    Thank You
    Last edited by AttalaEA; 03-21-2012 at 03:48 AM.

  7. #7
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: Multi Column Listbox change based on a selection from a combobox

    HI AttalaEA,

    Try below code. See attached workbook.

    Please Login or Register  to view this content.
    Regards,

    Joshi
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    02-21-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Multi Column Listbox change based on a selection from a combobox

    Quote Originally Posted by krjoshi View Post
    HI AttalaEA,

    Try below code. See attached workbook.

    Please Login or Register  to view this content.
    Regards,

    Joshi
    Hi Joshi,

    This is working great, Thank You So Much for your help and thank you all for helping me.

    Kind Regards,
    AttalaEA

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Multi Column Listbox change based on a selection from a combobox

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

  10. #10
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: Multi Column Listbox change based on a selection from a combobox

    You are welcome AttalaEA,

    Glad it helped.

    Please mark your questions as Solved once you are satisfied (Click the Edit button on your first post in the thread, Click Go Advanced, Select [SOLVED] from the Prefix dropdown and Click Save Changes)

    Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated.

    Best regards,

    Joshi

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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