display relevant info in one combo box when selecting a value from another combo box

[mailblade]

Hi there

I am in need of some expertise. I have been working on this form project and need some help coding the combo boxes.


I've been busy with the combo boxes in this particular project. Is there a way to populate a 2nd combo box with only relevant information? I am working with VB for this project.

E.g I have a department combo box. When I select "IT", I want the employee combo box to only display all the "IT" personnel.
Something along these lines:

Please Login or Register  to view this content.

An idea of what I want the action to perform. Now I am not quite sure how to implement all the coding. I have tried many options yet none work.

Any and all help would be appreciated.

[mehmetcik]

Are we talking about sheet based comboboxes or userform?

[mailblade]

I am referring to userform comboboxes. I've been using vb mostly. The user must select the department which will auto-display relevant employees.

Thank you for your reply.

[dafer660]

Greetings,

How are you populating the comboboxes with the personnel?
Straight from a "Excel DB Worksheet"? txt file? array?

Regards,
Daniel

[mailblade]

Good day,

Yes it is from a Excel DB Worksheet. The one field/column has all the employee details while the other DB Worksheet contains all the Departments (only 5). I have linked each employee to their relevant departments. There are other fields such as Shift times but they are not relevant to the combo boxes since they are entered manually. The form design is just a bit of a hassle with regards to displaying the relevant employee information.

Kind regards

[mehmetcik]

I created a sample for you

Sheets(3) refers to the third sheet in the workbook, change that when you know your sheet names
You can add as many departments as you want
And as many entries as you want
The code will adjust the userform automatically.

Please Login or Register  to view this content.

[mailblade]

This is a great example. It is exactly what I had in mind. I have already tested it and played around with it and it works!


Thank you very much! I appreciate all your help immensely

[mehmetcik]

Please Mark as Solved.

The tool is at the top

Any reputation (*) points appreciated. None of us gets paid here.

If you found someone's input useful, please take a second to click the * at the bottom left to let them know

[mailblade]

No problem, will do.

Thank you again
Cheers