+ Reply to Thread
Results 1 to 3 of 3

Changing Comboboxes to listboxes

  1. #1
    Registered User
    Join Date
    10-05-2021
    Location
    France
    MS-Off Ver
    Office 365
    Posts
    3

    Changing Comboboxes to listboxes

    Hello,

    I am very new to VBA. I created a Userform where I have multiple inter-dependent combo boxes which helps me to effect a filter in a Table and view the result in the first sheet. The combo boxes are poplulated with a double-click in the respective combo box. I would like to change the following:

    1. I would like to change the combo boxes to list boxes as combo box only allows me to select one item at a time and with list boxes I will be able to choose multiple items.
    2. Like the combo boxes could I populate a list box with a double-click which initially would be blank? And if I double-click on a different listbox it will reset all and then populate the one which is double-clicked
    3. Make the list boxes inter-dependent as in with any selection on a listbox, the others will be populated automatically with relevant data
    4. I would like to populate the filtered options in the respective cells under the headers (located in the range T6:AC6) in the sheet "Comparaison" with the command button "Filter Selection"
    5. Clear the items filtered with either the button "Clear all Filters" or the Command Button "Reset All" in the userform.
    6. Change the TextBox "N° Maco" also to a listbox and add it to the filtering option like other comboboxes.

    I have commented the used VBA codes which I managed to compile so far. I added a sample file with partial data of 3 months for testing.

    Please help me to achieve this and try and learn this interesting coding programme.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,051

    Re: Changing Comboboxes to listboxes

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do it for you this time: https://www.mrexcel.com/board/thread...boxes.1184644/ and https://www.ozgrid.com/forum/index.p...-to-listboxes/)
    Last edited by AliGW; 10-14-2021 at 10:01 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    10-05-2021
    Location
    France
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Changing Comboboxes to listboxes

    Hello AliGW, Thank you. I did not know that I have to post other forums link here. Now that I know, I will follow the instruction

+ 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] Changing ListBoxes into ComboBoxes and simlifying formulas
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2014, 07:08 AM
  2. ComboBoxes and ListBoxes Resizing on Their Own
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2013, 02:11 PM
  3. How to change selection in two listboxes by changing selection in a third listbox
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2013, 02:39 PM
  4. Change comboboxes to listboxes
    By Jcanguy in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-01-2010, 12:30 AM
  5. Removing Duplicates in Listboxes or Comboboxes
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-02-2010, 08:32 AM
  6. Changing rowsource of 2 listboxes based on 3rd listbox.
    By scadaman29325 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2008, 11:20 AM
  7. Listboxes and changing colors
    By droopy928gt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2006, 09:35 AM

Tags for this Thread

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