Need some help/advice

I have a spreadsheet with 40 rows

Each row contains the following

Column A = Last Name
Column B = First Name
Column C = Dollar Amount
Column D = Date
Column E = Comments (50 String Length)

I have a User Form with the following

Combobox1 = Column A and Column B
Textbox1 = Column A
Textbox2 = Column B
Textbox3 = Column C
Textbox4 = Column D
Textbox5 = Column E

Controlbutton1 = Update
Controlbutton2 = Cancel

I want to be able to load the combobox1 with column a/b rows 1 to 40

When a user scrolls the combobox1 I want the corresponding textboxes from
the spreadsheet to be filled in. (if the user scrolls the second name row
2, then textbox1 = row 2 col a, textbox1 = row 2 col b, etc…

If a user changes the data in the userform I want to update the
spreadsheet for that record.

Does this make any sense.

I need to be shown how this can be done. I'm not even sure it can be
done.