If statement in combobox

Hey there,
I've got something like this:
SHEET1.jpg SHEET2.jpg

I need modification to this code:

Please Login or Register  to view this content.

It fills my combobox1 with unique employee names, but I would like it to also take into account company name definied by combobox2 and linked into F2 cell. So something like if F2 = "XYZ" then fill combobox1 with unique employee names in that company else fill names with "ZYX" company.
Any help is greatly appreciated. Thank you!

Crossposted at: https://www.mrexcel.com/forum/excel-...ml#post5160721
(Got solved by crosspost)