Copy Contents of an ActiveX TextBox with a Macro

[TeachtheRook]

Hi,

I have a little issue with an ActiveX Textbox that gets filled with a macro as such:

Please Login or Register  to view this content.

(It takes the content from various strings and cell contents, but it is fundamentally the same as above.)


Then what I need is another macro that I can fix to a "Copy" button that goes into this textbox, selects all, and copies it.

Here's what I have so far:

Please Login or Register  to view this content.

The above is able to select the contents, but I'm not sure what the next step is. Ideally I want it to copy all that is selected to Clipboard. This could be done just by Ctrl+V after, but if I'm doing this alot its one less thing (and one less thing that could go wrong).

For the life of me thought I cannot figure out how to get this all to copy?

Anyone know? I'm thinking I'm missing something silly.

[Andy Pope]

Please Login or Register  to view this content.

Use a DataObject to transfer text to clipboard