Fill textbox from cells adjacent to lookup value

[MarkRCC]

Hi All

I am making a lookup userform for Regional Ecosystem IDs.
The host spreadsheet consists of 8 columns. The first column values will be the lookup value in a combobox on the userform. I am looking for code that will fill the other 7 textboxes with the data from the adjacent columns. I am sure this is possible, but I am not very experienced with VBA.

Thanks in advance!

 

[MarkRCC]

Similarly, I would be interested to know how to apply the VLOOKUP formula to VBA. As an attempted method of solving the above question, i tried using a code such as this:

Private Sub cboREID_Change()
Set ws = Worksheets("Redlands Condensed")

Application.WorksheetFunction.VLookup(cboREID.Value, ws.Range("REDD"), 2, False) = txtBioS.Value


End Sub

But this did not work. Any hints on how to fix the syntax?

P.S. cbo.REID is the combo box that has the Regional Ecosystem ID values.