Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Put selected Excel cell on the clipboard (Read 748 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Put selected Excel cell on the clipboard
26.04.15 at 21:02:41
 
Put selected Excel cell on the clipboard
 
At times, it can be convenient that Excel puts the contents of a selected cellt on the clipboard. This may be handy when repetitively copying from Excel cells.
 
The following code can be entered as an event handler for a worksheet:
 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim clipboard As New MSForms.DataObject
     
    clipboard.Clear
    clipboard.SetText Trim(Target.Value)
    clipboard.PutInClipboard
     
End Sub
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1