Copy cells from column to userform text boxes by selection

Hello all,

I have a worksheet with some data I would like to transfer to a userform. The form has a combobox that a testing modality can be selected. I want to know how to get the remainder of the userform text boxes to populate with the proper column information from the worksheet. Thank you for all your help.


Patrick