Re: Concatenate Text From Multiple Cells Into TextBox
hi thanks for initial thoughts.
Bill:
1. Do you want the textbox on the worksheet or in a userform? - Textbox
2. Is the textbox created each time a series of cells are to be concatenated or is there a permanent textbox cleared each time? - Each time, no permanent box. The idea is for it to be like a window you only get when you want to see text put together in different ways.
3. How will the textbox be cleared or deleted and rebuild when needed? Open to suggestions. Probably another macro button to close this 'window', or maybe an event like doubleclicking.
4. Are the cell strings to be separate lines in the textbox or concatenated and word wrapped? Lets start easy, just separate lines and we'll see how that goes.
Dave:
1. Does your code assume a permanent textbox1 is already created?[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Dave,
I get an error message:
"invalid use of me keyword'