Vba to copy range/cell value clipboard:

[pedie]

Hi, how can i make Vba to copy range/cell value to clipboard using worksheet on click event..i just want to make sure even the range value also can be copied with format such as bold and colour if possible.


Thanks in advance.

PS: Please give me 2 examples seperately, one for single cell and other for range.
Thanks again

 

[meldoc]

Hi Pedie

Try.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_BeforeDoubleClick(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range, Cancel <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Boolean</SPAN>)<br>  <SPAN style="color:#00007F">If</SPAN> Target.Address = "$A$1" <SPAN style="color:#00007F">Then</SPAN> Range("A1").Copy<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br><br><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_BeforeDoubleClick(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range, Cancel <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Boolean</SPAN>)<br>  <SPAN style="color:#00007F">If</SPAN> Target.Address = "$A$1" <SPAN style="color:#00007F">Then</SPAN> Range("A1:A10").Copy<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[pedie]

Hi Brian, thanks alot for your code....sorry didnt have time to check back lastnight...

This work great within excel...will this also work if i want to copy this to another application? yes..i think so..

Thanks again Brian!!!

 

[meldoc]

Yes Pedie

It should copy to other applications.

Also when you copy a range, you automatically copy all the attributes Font, colour, Bold, ETC.
It's only when you paste do you get the Choice of what to include and what to leave out, xlPasteValues, xlPasteValuesAndNumberFormats, ETC.