Populate a UserForm

[WHWALDREP]

I have some textboxs and some comboboxs, on a user form I want them to populate according to the row the cell is selected on.

Example:

cell c15 is selected,

UserForm1 Textbox2 populates with value of A15
UserForm1 Textbox1 populates with value of D15
UserForm1 Combobox2 populates with value of F15

And is the user changes a value I need it to update the cell.

Thank You for the help.

[Simon Lloyd]

they are achieved like this

Please Login or Register  to view this content.

[WHWALDREP]

Ok, thank you this is what I have.

Please Login or Register  to view this content.

Module is

Please Login or Register  to view this content.

Which seems to work good, But what do I need to do to also make it change the cell value If they change the data on the form.?

[mudraker]

they are achieved like this

Please Login or Register  to view this content.

[Simon Lloyd]

For the form to change the data on the sheet try:

Please Login or Register  to view this content.

[WHWALDREP]

One other question and thank you for all your help that worked great.

If the user selects rows 10 - 15 How can I make it change all of them, and display only common info.
Example

if mfg = A-B on 10-15 display the manufacturer and if I change cost it would change on all 5 rows.

Thank you so much.

[WHWALDREP]

Ok how can I make this work?

Please Login or Register  to view this content.

[WHWALDREP]

Ok this what I have thus far. But now it changes the column of rows that is selected, I need it to change column B when multiply rows are selected. Thanks for the help.

Please Login or Register  to view this content.

[mikerickson]

This will put the userform's value from Contol "lead" into cell B of every selected row.

Please Login or Register  to view this content.

[WHWALDREP]

This will put the userform's value from Contol "lead" into cell B of every selected row.

Please Login or Register  to view this content.

the whole rows a not selected just a range of rows like C1:C15 or E13:E53


Thanxs

[WHWALDREP]

Heres what I got it works but does not look like it was the best way.

Please Login or Register  to view this content.