Modify cells using userform

[Emoncada]

What I would like to do is have a userform and be able to have a dropdown with values from sheet2 A:A and if I select a value the other txtboxes will populate that rows values.

So if I select a value in A20

Txtbox1 = B20
Txtbox2 = C20
Txtbox3 = D20
etc...

But I would then like to modify or change a value then have it update those fields.

How can I accomplish that?

[dxider]

Well, you need to create a Macro Enabled file.

ExcelUpdateValues.zip

Please let me know if this works.