PDA

View Full Version : Modify cells using userform



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?

dxider
09-11-2015, 09:24 AM
Well, you need to create a Macro Enabled file.

14373

Please let me know if this works.