Userform Combo Box Search and Pull Results

[gilly01625]

Hey,

I have the below userform which is being used to create an invoice. My aim is the have the user select a reference number, which is linked to a record of worked hours from a worksheet, in the combo box at the start of each item (items 1 through 10) - once a reference number has been selected, the text boxes in said row are populated with data linked to the reference (description, unit/hours, pay, and total).

Is this possible?

Thanks

 

[gilly01625]

Can anyone help please?

 

[mumps]

It is hard to work with pictures. Also, it would be helpful if we could see the sheet containing the record of worked hours. It would be easier to help if you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).