First we get all the IDs into our combo-box using a looping process. Next we get the relevant data into our text-boxes based on our selection from the ID in the combo-box. This process using VBA automates the complete process of retrieving data from a worksheet into the combo-box and text-box controls of a user-form. The automation also reminds us of a Vlookup in Excel.
The complete VBA code is available at this link: http://www.exceltrainingvideos.com/how-to-get-data-from-
worksheet-into-combobox-and-text
آی-ویدئو