question

SamirRanjanBhowmik-4401 avatar image
0 Votes"
SamirRanjanBhowmik-4401 asked VikiJi-MSFT edited

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 link to the sample file with partial data of 3 months for testing.

https://www.dropbox.com/scl/fi/cpwolpwfhqfkbbpbgvqqj/Comparaison-last-trial.xlsm?dl=0&rlkey=ugewhmw6yvm094cjixwxcxffp

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

Thank you

office-vba-devoffice-scripts-excel-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SamirRanjanBhowmik-4401,
Welcome to Q&A forum!
I will remove the irrelevant tag office-excel-itpro that focuses on general issues about Excel client, thanks for your understanding.

0 Votes 0 ·

0 Answers