Column to delimited text box, then back to column

[ignetus]

Hello, I was wondering if any of you would know how to do this in Excel using VBA:

I have a very long column A containing delimited texts, such as:

ROOF, PARAPET, METAL COPING
BASE FLASHING, TERRACOTTA PANEL
BRICK WALL, SIDEWALK

I'd like to press a command button and have those columns copied onto an existing text box, which would read:

ROOF, PARAPET, METAL COPING, BASE FLASHING, TERRACOTTA PANEL, BRICK WALL, SIDEWALK

After which, it would convert back into a single column B:

ROOF
PARAPET
METAL COPING
BASE FLASHING
TERRACOTTA PANEL
BRICK PANEL
SIDEWALK

If there is another, better way to get from my first column to my final column, perhaps without the text box middle man, that would be great. Thanks!

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[ignetus]

Oh wow, perfect, even better than what I had envisioned! Thanks!

I added the following into the beginning of the code so that if the list is subsequently updated to include fewer terms, the residual terms are automatically erased:

Please Login or Register  to view this content.

[MickG]

You're welcome