Hi,

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

Sheet1.TextBox1.Text = "blah blah blah"
(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:

Sheet1.TextBox1.Activate
Sheet1.TextBox1.SelStart = 0
Sheet1.TextBox1.SelLength = Len(Sheet1.TextBox1.Text)
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.