Copy cell data and paste it into textbox on form

[jpruffle]

Hi,

Please can someone offer me some advice on the following problem. I have a form that adds and edits data on a sheet. I would like the user to be able to select any row of that data and then a macro copies the data from column A for example (ID1234). Launch my form (FmAddTask) and then paste it into the combocbox (idlookup).

Hence enabling immediate editing of that row of data via the form.

I made a start:

Please Login or Register  to view this content.

But it simply doesn't work. Any help would be graetly appreciated.

Thank you in advance.

[romperstomper]

Assuming a userform called EngageTask:

Please Login or Register  to view this content.

[jpruffle]

Absolutely Fantastic Thank you.