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: 20
  • Capture 3.JPG
    Capture 3.JPG
    22.7 KB · Views: 20
  • Capture.JPG
    Capture.JPG
    46.7 KB · Views: 19

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,224,825
Messages
6,181,190
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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