Checkboxes to copy different lines to clipboard

Hi all,

So, I'm sure this will be quite simple for most of you but it seems to be nightmare to me! I've read a few threads and tried several different approaches but keep failing :-/

I want excel to do what I think to be very simple: Copy different lines to clipboard depending on the checkboxes active. They're only four!
The thing is, I know how to copy X text if X checkbox is active and concatenate it with the next statement in a cell - I could then copy this cell. But I would like the clipboard text to respect line breaks and to not have quotation marks. I'm afraid this can be only archive using VBA, right?

So, in the example attached file, if checkboxes 1 and 3 are active, the following text should be available in the clipboard to paste in any other application:

Copy this text if checkbox 1 is active. This can be a 50 characters long phrase.
Copy this text if checkbox 3 is active. This can be a 80 characters long phrase.

Exactly like this. Is this possible? If VBA is not needed I could go with that too.

Many, may thanks in advance!

Hi AlphaFrog,

Sorry for getting back so late!
Thank you for replying and for trying to help.

Unfortunately I wont be able to position the text or chechboxes that way.
Is there any other way to get the job done? Something that translates to (i'm sorry for the dumbness) If checkbox 1 and 2 are checked Then copy C3 & (paragraph) C4.

I'll have a button to action the code.

Thanks