Populate worksheet textboxes from listbox

[rodgersmg]

I'm having Trouble trying to bring values into a worksheet.
I have 9 textboxes that will be filled from an external sheet. I perform a search over a listbox and double click the result I want.
If I were to populate textboxes on a userform I would use

Please Login or Register  to view this content.

Obviously "ME.Controls" doesn't really work on a worksheet. I can make one work by saying

Please Login or Register  to view this content.

but

Please Login or Register  to view this content.

doesn't work either
how do I get around this?

Thanks for the helps!

Michael

[Norie]

What type of controls are they, Forms or ActiveX?

You can refer to Forms textboxes like this,

Please Login or Register  to view this content.

and ActiveX like this.

Please Login or Register  to view this content.

[rodgersmg]

They're all activeX
I'd like to loop though them though, like the UF example I had.

[Norie]

You can use the 2nd code I posted then, just replace 'TextBox1' with the names of the textboxes.

Please Login or Register  to view this content.

[rodgersmg]

Thanks Norie, I had almost had it, except for the "Object"

Please Login or Register  to view this content.

Works a treat, thanks for the help!