Copy & Paste one or more cell values to

[scott5]

Tried all day to find a way of selecting text ( from several cells) on one sheet and then having it pasted into the textbox on another sheet.
Is it possible?.

I did originally paste the text to a cell but it makes the row's vary in size depending on the copied text and gets a bit annoying. Seems to be
This is the paste to Cell code

Please Login or Register  to view this content.

Any help gratefully appreciated

[shg]

Welcome to the forum.

You code makes no reference to a textbox. If you want the catenated result of several cells added to a textbox, you'll need additional code.

Please post a workbook and explain in context.

[VBA Noob]

Maybe something like.

Change range to you're range

Please Login or Register  to view this content.

VBA Noob

[scott5]

Hi
Not sure how to post workbook?
Also not explaining it very well.(Try Again)
Three pages of the workbook have data in them, the common ref is a "SAP No".
I have a front sheet with a listbox referencing a column on the first sheet by location name.
When the name in the listbox is selected the the macro collects other data linked to the "Sap No" from sheets 2 + 3 and populates the front sheet using simple copy and paste.
The problem is that the data copied in sheet3 can be any number of rows on the same column and varying lenghts of text in each row.
And when this is paste into a cell on the front sheet it causes the row high to vary to accomodate the word wrap and show all the data.
I have placed a TextBox (AllFeedBack) on the front sheet and would like to paste the data from Sheet3 into that so the row height does not vary.
Hope this is clearer.
Let me know how to post the workbook and I will do so
Cheers Brian

[scott5]

Sorted the problem.
Used VB Code (Discovered on line) to copy and paste text contents of several cells into one cell.
Then used the link Cell property of the TextBox to reference the new cell containing all the text.
Works a treat and no more rows expanding and contracting.