Emoncada
09-11-2015, 06:29 AM
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?
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?