Creating a listbox/droplist with multiple selections that can be entered in a paragraph

[rippedit123]

Hi everyone,

As requested by helpful Aardigspook, I have created a new thread in the hope that someone can help me. Here is the old thread:-

http://www.excelforum.com/excel-gene...ml#post4181208

I want to create a "custom paragraph" in which I can have cell values entered at different locations. Aardigspook has helped me create just that in the previous thread. But now I want to again do the same thing, but instead of a single cell value, I want to have a listbox/droplist where I can select multiple choices and these choices would then appear within the paragraph.


As you will see from previous thread I'm using a paragraph from microsoft's website and I want to continue using this as an example for the sake of continuity.....


okay, so lets use the same microsoft paragraph as an example and lets say that whatever multiple selections I choose from the list/dropdown box, they should appear where currently &H1& is located (near the end of paragraph).

=A1&" has consistently transformed the way that people live, work, play and connect through great "&B1&". We are inspired every day by the genuine belief that we can "&C1&" the "&D1&" for the better. Here on our UK website you'll find out more about how we are driving advances in "&E1&", developing new ways for people to "&F1&" with technology at home, at work and on the move, while transforming "&G1&" and public services and supporting the UK "&H1&"."

Just for the sake of an example, I want H1 cell to have multiple choices of days of the week. But my ONLY selections are Tue and Thur from that list, which must now appear at the end of the paragraph:-

listboxdaysselect06.png

Hence, the end result (even though the sentence sounds silly, lol!) should say:-

"with technology at home, at work and on the move, while transforming education and public services and supporting the UK Tuesday Thursday.

[pjwhitfield]

I would cycle through the listbox finding the Selected items and append them to a single variable, then at the end replace the &H1& with the variable

Please Login or Register  to view this content.

[rippedit123]

Forgive me pywhitfield, but that is too complicated for me and I'd need it explained in more basic layman's terms.