two userform comboboxs depend each other by value

Dear All ;
i have a userform contain two comboboxs ( Combobox1 contain Names Exist in Column B and Combobox2 contain Invoice No. in Column C ) . i need to do the followin :
1-List of Combobox1 must be the names in column B , and List of Combobox2 must be the Invoice No. in column C.
2- Macro , when i select the name from combobox1 and press the Tab button on keybord i should get the Invoice No. ( or Invoices No. if mor than 1 to the same Name ) in combobox2 , and if i select typed the Invoice No. in combobox2 and press Tab Button i should get the name in combobox1.

see attched file as example.

Thanks for your help

option, please check attachment, without pressing TAB to update another combobox value

Thanks Mr. Watersev , this is the code what i need , it works perfect .

Thanks a lot