Paste specific text to clipborad on click of excel button

Hello friends ,
Can anyone help me ,

i want to make a button in excel sheet.
When i will click that button the text "Button value Copied" will be copied in the clipboard.

Can any one write some code for that button??

PLease help

Anyone help,code to paste specific text to clipboard
Yet i m searching...

Ruth

why do you want to do this

why do you want to do this ?
... if you want to copy something to clipboard, put it in a cell, and copy the cell.. you can record a macro to do this.
more here:
http://excelexperts.com/Learn-VBA

To automate some task faster

Dear Sirs ,
i want to make some task faster , its not possible to make a button on the click of which i can copy something to the clipboard....

Regards
Ruth

Nick's picture

ok, well take a look at the

ok, well take a look at the link above..

my point is really though that in Excel, you don't need to use the clipboard..

check this out:
http://excelexperts.com/copy-values-vba