Populate textbox with particular column from multiselect listbox

You are using A:D as a RowSource. This will include over a million rows. I have added a named formula that will automatically select the actual data.

You are using your column headings as data. This allows the user to click on the headings. The named formula also takes care of this, and I set ColumnHeads to True.

The textbox MultiLine property must be set to True.

There is a spacing problem in the textboxes that needs a little more thought.

Similar logic applied to the second textbox.

I have not looked at your last item at all yet.

Originally Posted by dale.lebar

A further goal would be to ensure that the results in the textboxes are easy discernable by clause, some of the information in the [Plan] and [Action] columns will be multiple lines with blank spaces, so if a delineation of a bunch of '-----------' could be inserted between each line that would make it much, much easier to read.

I have given this some more thought and a little experimentation. Fields with multiple lines will be difficult to format into a text box. The text box has no inherent columns, it's just plain lines of text. If you include a long field, or a multiline field, it won't be confined to a column, it will just go to the end of the line and wrap around. Doing the kind of formatting you want in a textbox is difficult for two reasons:

1. You have to measure the length of every text string and pad with blanks where necessary to make it fit where you want it. Tabs can be used strategically to help with wraparound but don't solve the whole problem.
   
2. Unless you use a fixed-width font like Courier, there is no good way to know how many points of space a word or phrase will take up in the textbox, making #1 even more difficult.

Consider putting your output to a worksheet rather than textboxes on a form. That makes all this formatting trivial.