'Wクリック時にセルの値をクリップボードへ
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim moji As String
If Target.Value <> "ここをWクリック" Then
Application.StatusBar = "コピーセル対象外"
Else
moji = Cells(Target.Row, Target.Column + 7)
Application.StatusBar = "Copy: " & moji
CreateObject("WScript.Shell").Exec("clip").StdIn.Write moji
End If
Cancel = True
End Sub