I have two combo box on a user form "Name" and "ID". When I select name, it automatically displays ID correspond to that in excel (source). I want, if I put either of the information (ID or name) other one automatically displays.