Populating unique values to multiple inter-connected combo boxes in an userform from a table in Excel

SamirBhowmik

New Member
Joined
Sep 23, 2021
Messages
26
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
I am quite new to vba. I am trying to create an userform with multiple combo boxes where the data has to be loaded from the columns of the table "DynamicPath_2" in the sheet "MDB" and I need only the unique values to load on these combo boxes. Also I need to link or make dependencies from one combo box to the other as in when I select a value from a combo box the others should contain only the unique options available in the other corresponding columns.

I have added the picture of my userform and the headers of the table.



So the combo boxes related the headers are:

Source --> Fiche Source
Division --> Division
Name of Project --> Nom Projet
N° Maco --> Projets en cours (It should automatically populate a unique number related to Name
of project)
Status --> Statut Projet
Client --> Client
Resp Pole --> Pole
RFC --> RfC détail
Month --> Mois

And finally the Reset All button should clear all selected items, and Filter Selection button should filter the table based on values selected in the combo box or combo boxes.
I have checked many posts but none of them seem to exactly give what I am looking for

Could anyone please help me to build this?

Thank you !!!
 

Attachments

  • Capture 2.JPG
    Capture 2.JPG
    46.6 KB · Views: 17
  • Capture 3.JPG
    Capture 3.JPG
    22.7 KB · Views: 17
  • Capture.JPG
    Capture.JPG
    46.7 KB · Views: 16

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,214,515
Messages
6,119,974
Members
448,934
Latest member
audette89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top