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
Bookmarks