copy text to the clipboard

[Crazy_Ivan]

Hi all,

I would like to run a macro that copies specific text to the clipboard.

The text does not change - so all I need is to be able to click the macro button and have "loginaddress" held in the clipboard.

Any ideas?

Thanks!

 

[My Aswer Is This]

There may be a easier way. But this is the way I know:

Sub Copy_Me()
'Modified 6/21/18 4:19 AM EDT
ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 573, 98.25, 171.75 _
        , 61.5).Select
    Selection.ShapeRange(1).TextFrame2.TextRange.Characters.Text = "loginaddress"
    Selection.ShapeRange(1).TextFrame2.TextRange.Copy
    Selection.Delete
End Sub

 

[Crazy_Ivan]

Thanks a lot, works perfectly!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks a lot, works perfectly!